Openform action from subform

  • Thread starter Thread starter m
  • Start date Start date
M

m

Hi,

I have a one line macro to open a more detailed form if you press a button
that runs a macro. The macro opens the form withe the following in the
where statement...

[ID]=[Forms]![Pay history]![ID]

ID is the primary key in the pay history table from which these originate.
It works when I open the Pay history form, but that form is really a subform
that goes to the Employees form. When I run it through the Employees form,
I get prompted for the ID#. Any ideas?

Thanks
Mike
 
Back
Top