Select subform's query criteria from form's unbound cbo

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

Guest

I want users to be able to select a name from a form's unbound combo box and
that selection to automatically become the criteria for the subform's
underlying query, without the parameter box for the query popping up. How do
I do this? I'm new to VBA and not an Access 2003 whiz either.

TIA for your help!
 
WorkerBee said:
I want users to be able to select a name from a form's unbound combo
box and that selection to automatically become the criteria for the
subform's underlying query, without the parameter box for the query
popping up. How do I do this? I'm new to VBA and not an Access 2003
whiz either.

TIA for your help!
Click to expand...

You should be able to include that in the MasterLink and ChildLink
properties of the subform control and it would all be handled automatically.
 
How do I include this in the MasterLink and ChildLink properties of the
subfom control? Currently the properties are set to Scientist ID which is
the primary key for the table used in the form, and the secondary key for the
table I'm using in the subform. In the MasterLink property I tried to
reference the unbound cbo on the form and identify the column where the
Scientist ID is stored [cboAuthorName].Column(2), but no luck.

Is there something I'm missing

WB

Please point me in the right direction to
 
Back
Top