update listbox

[golan]

hello; i have a form with combox (renter) and 2 listboxs (contract and
assets).
the data to the lisboxs come from aqeries that dependent the data in the
combox.
when i choose a renter(comobox) i see in first list box the contract and at
the second i see the the assets. but, if i not click on the listboxs the data
is not update the table.
there is any macro or code or somthing else to update them or to click them
automatically when i update the combobox?

 

[John W. Vinson]

hello; i have a form with combox (renter) and 2 listboxs (contract and
assets).
the data to the lisboxs come from aqeries that dependent the data in the
combox.
when i choose a renter(comobox) i see in first list box the contract and at
the second i see the the assets. but, if i not click on the listboxs the data
is not update the table.
there is any macro or code or somthing else to update them or to click them
automatically when i update the combobox?

The purpose of a listbox is to allow the user to make a selection. It sounds
like you don't need to make a selection - that the listboxes only display one
row!?

If so, your table design may be incorrect. It all starts with the tables: what
tables do you have in the database? How are they related? What is the
Recordsource of this form? And most importantly, what are the control sources
of these two listboxes? If all you're doing is copying a contract and assets
value from one table to store them redundantly in another table, you're on the
wrong track!

 

[JString]

Not sure if I'm understanding your problem correctly, but if you need the
listbox to be updated with current data from the table (and not the other way
around), you can use a second, hidden form that is opened in dialog mode to
run the code that gets the current data and refreshes the listbox.