I have a form with which I want to populate two fields (A & B) based on another fields value (C) afterupdate.
I have created a Query which will return the two values (for A & B) based on the other (C) using a where clause. However I'm getting stuck on how to link the two fields (A & B) values to the query result.
I checked the query which runs OK. However if I try and populate the two fields (A & B) using code the query returns an error saying there's a parameter required (I'm guessing this is the variable in the where clause).
I looked through the help and I'm thinking I have to use ADO to populate the variable - is this the case? If so how would I go about it?
Or is there another way to do this?
Thanks in advance