Link two forms

J

Jasun74

Ive done this before and for the life of me I cant remember how I did it!!

I have a main form called "TROLLEY" with the field "M/C"
I want to have a macro (as I get on better with them) that will open a new
form called "SERVICE SCHEDULE" with the field "MC_#" linked to the main form
field "M/C" on the double click event.

Ive been trying this in the "where condition"
[Forms].[trolley].[m/c]=[Forms].[mc #]
It opens the service schedule form but doesnt filter it.
 

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

Filter a subform from a combobox selection 2
Main Form and two Subforms 2
Filtering subforms 1
Access Sub form opens before the main form in MS Access 0
Linked forms 1
Mimic Split Form with Two Subforms 0
Click a subform field to open relevant form 5
Access Daily Entry with multiple entries per field 0

Top