Needing CustomerID filled in (1 Viewer)

mx36

New member
Local time
Today, 07:20
Joined
Sep 1, 2018
Messages
3
I have 2 forms, one set up with customer info and the other set up with billing info. The billing info forum is pretty much set up with a long list of parts that I normally use for repair work. I can go in and put quantities in each box for each part and then have it set up to calculate total dollar amount for all supplies with taxes.

What I am trying to do is put a command button in the customer form that when clicked it will bring me to the billing form and put the customerId number and possible customer name on it automatically. Right now when I click on it, it brings me to a new blank forum with out the id or name.

Hopefully that all makes sense and you can guide me in the right direction.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 07:20
Joined
Aug 30, 2003
Messages
36,125
One way:

DoCmd.OpenForm "BillingFormName"...
Forms!BillingFormName.TextboxName = Me.TextboxName
 

mx36

New member
Local time
Today, 07:20
Joined
Sep 1, 2018
Messages
3
One way:

DoCmd.OpenForm "BillingFormName"...
Forms!BillingFormName.TextboxName = Me.TextboxName

Thank you, got me what I needed plus allowed me to get the first and last name on it.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 07:20
Joined
Aug 30, 2003
Messages
36,125
No problem, and welcome to the site by the way! Hopefully you're just displaying the customer name on the second form. You normally shouldn't save that in related tables, just the ID.
 

Users who are viewing this thread

Top Bottom