Openform action from subform

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a record to a subform with a macro 2
OpenForm: Where Condition 1
understanding macros 6
MS Access 2010 Training database 0
OpenForm macro with 2 criteria 2
Open subform to specific record 2
Use Macro to Filter records in Subform on open 0
Problem with form--subform 5

Top