Form macro

  • Thread starter Thread starter Phil
  • Start date Start date
P

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)
 
---------- "Phil said:
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]
Click to expand...

Phil,

have you thought of using a subform for the printers? It would do what
you want automatically once set up.

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de
 
Back
Top