G
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!
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!