Using subform to get parameters for Open Form

  • Thread starter Thread starter Deena
  • Start date Start date
D

Deena

I have a form that has two subforms that are synchronized
in the same manner as Northwind's "CustomersOrders"
form. I am now trying to add a button on the main form
that will provide more detail on the current record in
the 1st subform by opening a form with more fields. When
I click the button, I am asked for input instead of the
data being passed to the macro's Open Form's "Where"
condition. If I open the subform directly and select a
record, then do a "Run Macro" the new form opens and goes
to the correct record, so I know my "Where" clause is
correct when the form is not being used as a subform. If
I open the main form containing the subform, and do
a "Run Macro" it asks for the parameter information to be
input. Any suggestions or info, please. I do not do VBA
coding.
 
Back
Top