Parameterised SQL Select Query and Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top