Refresh the List of a Combo Box based on a parametric query

[phabio]

I have a Mask with a Text Box and a Combo Box.
The List of the Combo Box is produced by a SELECT (at the bottom of the page) with the WHERE condition that depends on the content of the Text Box.
The select works the first time that I open the Mask, then if I change the content of the Text Box the List doesn't change anymore.

Please help me, How can I refresh the List without closing and reopening the Mask???

Thank you

Fabio (Rome)


--------------------------------------------------
SELECT
[NetworkNodeType].[NetworkNodeTypeID],
[NetworkNodeType].[NetworkNodeTypeNome], [NetworkNodeOfNetworkType].[ConnectNetworkType], [NetworkNodeOfNetworkType].[ConnectNetworkNodeType]
FROM
NetworkNodeType
INNER JOIN
NetworkNodeOfNetworkType
ON
[NetworkNodeType].[NetworkNodeTypeID]=[NetworkNodeOfNetworkType].[ConnectNetworkNodeType]
WHERE
((([NetworkNodeOfNetworkType].[ConnectNetworkType])=
[Forms]![M_NetworkNodeInventory]![NetworkNode_NetworkType]));
----------------------------------------

 

[thornmastr]

Put something like this air code in the after update event of your text box:

Me.mycomboboxname.requery
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[phabio]

Me.mycomboboxname.requery !!!

Great! It works perfectly.


Fabio (Rome)