VBA code required I think - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

VBA code required I think

Mick Bullous

4 years ago

I have used your invoicing template and adapted it for my service business. I have created a button on the main menu to open the customer form to add a new customer. Once the customer is added, how can I make the appointments button (in your database the orders button) open a new appointment (in your dattabase new order) update the customer field to the new customer I have just inputed so I can add appointment details?

	Kevin Robertson @Reply 4 years ago
I have already gave you an answer here. If that isn't what you're looking for please post some images of your form so we can visually see what you need. Note: Posting the same question in multiple forums won't lead to solving your issue any quicker.

	Mick Bullous OP @Reply 4 years ago

	Adam Schwanz @Reply 4 years ago
Yea the answer Kevin gave you in the last video is exactly what you need. Default Value

	Mick Bullous OP @Reply 4 years ago
So how do I set it... I dont understand what to write in the default line on the form

	Adam Schwanz @Reply 4 years ago
Go to default value of the combo box and set it to Forms!CustomerF!CustomerID

	Mick Bullous OP @Reply 4 years ago
Thank you...That seems to work. I have also added a me.refresh to the customer FirstName and the customer LastName fields so when I click the appointments button it updates the customer form before opening the appointment form.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View