Using a command button to open a new form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write the code in the Command Button that opens a new
formcalled form2, and has the say the Customer information already filled in
from form1.

Any insight would be helpful.

Thanks
 
DoCmd.OpenForm "subform", acNormal, , , , , me!customerID

use openargs to pass, say the customerID to "subform"
 
Thanks Vimal,
As I did not design the database, should I use this line of code for each
item I wish to bring to the new form? i.e.
DoCmd.OpenForm "Subform", acNormal, , , , , Me!firstname
DoCmd.OpenForm "subform",acNormal, , , , ,Me!lastname
etc...

The Database does not have a seperate customer list to work with, and what
I'm trying to do is when the form2 is opened the customer information is
brought over to the new form. firstname, lastname, address, city, state,
zip, phone.

Hope this helps you.

--
Schaefer Networking
Everett Buel


Vimal Ori said:
DoCmd.OpenForm "subform", acNormal, , , , , me!customerID

use openargs to pass, say the customerID to "subform"
Click to expand...
 
Back
Top