Form Buttons

[Topham]

Hello,

Im not sure if i have poste in the right place.

Im currently doing a Database for a Ride inpectors company. What it is, Ive created a form where you create New Customers, with customer id and that and then on this form i have a button to open a new form for 'New Rides'. Now this Form has a customer id field same as in the new customers form. So i would like if able to, to have 1 button to save the form, open the new rides form and in the 'CustomerID' field have the CustomerID that the 'New Customer' form gave when creating the new customer.

This would be Much Appreciated.

Regards,
Topham

 

[Topham]

forgot to say that both forms are open at the same time if that makes anything easier.

 

[Mr. B]

One of the parameters, that last one, of the Docmd.OpenForm method is the "OpenArgs" parameter. You can use this feature to pass the CustomerId from the Customer form to the Rides form.

Then once the Rides form is open you can read the value from that form's OpenArgs property into the field for the CustomerID.