Solved New Order for Customer Button

[NatAccessNewbie]

Hello,

I'm building a database that will include VBA for the very first time - eek! Its a simple database consisting to track my customers and their orders. I've used Access for years but never used VBA or macros.

I'm hoping someone can talk me through how I place a button on my customer details form that will open a form to record a new order for that customer.

TIA
Nat

 

[June7]

You can use the design wizard and it will build macro then you can convert macro to VBA. Once you get familiar with coding, stop using wizard. I don't use wizards because they do things I don't like.

Code would have to pass customer ID to order form when opening. More than one way to do that. OpenArgs would be my preference.

But you could make Orders a subform to Customer and button code would not be needed. But then I suppose you also have OrderDetails so that would be a 3rd tier form - form/subform/subsubform. I've done that in a small db and not a single line of code (macro or VBA) created.

 

[theDBguy]

Hi. I agree, consider using a form/subform setup first. You might not need to use a button and VBA yet.

 

[NatAccessNewbie]

I've done it! Thank you

 

[theDBguy]

I've done it! Thank you

Congratulations! Good luck with your project.