Parameter Query

Ben · June 27th, 2003, 04:44 AM

Hi All,

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
Ben

Phil Sieben · June 27th, 2003, 12:13 PM

Quote:

quote:Hi,
You need to create a query in the query collection in code. Don't include the WHERE part in the SQL string. But you've to specify the Queryname.Parameter(s) in code and accord to these the values of the A en B fields.

Cheers,
Phil Sieben.

Quote:

quote:Originally posted by Ben
Hi All,

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
Ben