Hello,
I just started my first larger ms-access project. I am using a button to open a different Form with data mode set to "Add". When the form is opened, I would like to automatically insert a temporary variable into one of the fields.
A bit more context: I have two forms, one that shows information on a person (based on a person table) and one that shows information on a specific order a specific person has made (based on an order table). I also created a button in the person form that opens the order form to create a new order. I have saved the person's name in a temporary variable. When the order form opens, I would like to automatically insert the person's name into the appropriate field.
So far, I have only worked with Macros, so I have no experience with Modules, although I'm willing to learn!
I would be grateful for any pointers!
Best,
Max
I just started my first larger ms-access project. I am using a button to open a different Form with data mode set to "Add". When the form is opened, I would like to automatically insert a temporary variable into one of the fields.
A bit more context: I have two forms, one that shows information on a person (based on a person table) and one that shows information on a specific order a specific person has made (based on an order table). I also created a button in the person form that opens the order form to create a new order. I have saved the person's name in a temporary variable. When the order form opens, I would like to automatically insert the person's name into the appropriate field.
So far, I have only worked with Macros, so I have no experience with Modules, although I'm willing to learn!
I would be grateful for any pointers!
Best,
Max