Need Help in 'Query by Form' feature ...

M

Me

I have a form with so called key fields say - A,B,C & D

B's list value is populated after value is entered in field 'A'.
Then using field values of 'A' and 'B', values in 'C' and 'D' are populated.

This works just fine. However, when I want to do a 'Search by Form' and
enter values for field 'A', 1st of all List values in field 'B' aren't
populated as it happens when record is newly created. Still if I know the
value for field
'B' and I enter it, I get error, the value entered is not in the item list
(for field 'B').
since the list value is blank.

I am running into problems 'cause if users are unable to search the records
that they entered.

How can I fix this?

Thank you very much for you help in advance!
-Me
 
Top