Forms Macro

[Phil]

I am trying to get a form I have attached to another form to be connected to
the main form. Let me explain. I have a form called customers. I have placed
a command button on the bottom of this form called printers. When I click on
the printer form button I want it to relate to whatever customer record is
currently open in the customers form. When I click on the advance button on
the customers form I want the corresponding records in the printers form to
advance also. So if the customers form in on customer #2 the printer's form
should be showing what printers customer #2 has in their possession. I have
this code, which I got from a book and it is supposed to do exactly what I
am trying to do, but for some reason it isn't working. The code is:
[CustomerID] = [Forms}! [frmCustomers] ! [CustomerID]

I have tried switching the frmCustomers to frmPrinters but that doesn't work
either. Any help?



Thanks,

Phil

(e-mail address removed)

 

[Gary Miller]

Phil,

Would a subform work for you? With a subform the records
will changer per CustomerID as you describe and it is a snap
to setup. You just need to link the Master/Child fields as
the CustomerID.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________