ComboBox with a query problem

[Guest]

Hi
On a form I have a combox that its Row Source type is a Table/Query and its Row source is a Select ..
When I use the WHERE (a value of the table = to a field on my form) i get a problem
The query seems to get stuck to the same value when I move back and forth in the records from that form
What is the prob
WHERE (([AudioVideo].[Kit])=([Forms]![KITassembly]![Kit]))

It shows properly when I print a filtered report on that record, the unbound text get the results from the 'after update'
Me![Desc] = Me![ID_Asset].Column(1

If I use only a reference within the table
WHERE (([AudioVideo].[On_Loan])=False);
Then the display is all ok
It seems that the Query run only once and cannot detect that the record has changed
Any help would be great!

 

[Jeff Boyce]

Mark

Does the combo box "know" that you've changed the value on the form? Try
doing a cboYourComboBox.Requery in the AfterUpdate event of the field you
are using.