Parameterised SQL Select Query and Forms

E

Eric

Hello all,

I have a parameterised select query which works fine, and a form that the
user fills in. On the form is a combobox bound to a field in a table. Now
what I would like to do is have the user select an option from the combobox
and then run the stored query so that corresponding data from the same record
but (obviously) different field is displayed in another part of the form (say
a text box). All this to happen without user intervention - ie all in VBA.
I know it must be possible I just do not know how.

All suggestions gratefully accepted
 
P

pietlinden

Hello all,

I have a parameterised select query which works fine, and a form that the
user fills in. On the form is a combobox bound to a field in a table. Now
what I would like to do is have the user select an option from the combobox
and then run the stored query so that corresponding data from the same record
but (obviously) different field is displayed in another part of the form (say
a text box). All this to happen without user intervention - ie all in VBA.
I know it must be possible I just do not know how.

All suggestions gratefully accepted
Click to expand...

So you're trying to write data you get from running the query into a
control on your form? Probably better off basing the form on a query
that includes that, or use a DLookup.
 
Top