List Box Controlling Field

[ejmiller2]

Hello all ...

i have a list box whose rowsource is a query. I would like this list box to then control a field. On update i would like first for the listbox to requery then the controlsource (i.e. the field it controls). Is this possible?....

if not, how do i get the field to be controlled by a query?...

hope this is understandable...thanks everyone

eric

 

[Rolliee]

In the listbox properties there is a Row Type or something like that. The choices are "Field Values", "Query/Table" and another - I forget. You can look at it though. Make the Type "Query/Table" and then put the query or table in the "RowSource" property which is just below the earlier described one. This can be hard coded in the listbox or plugged with code. Want and example - let me know.