Hey all
I’m new to base and macros in general. I’ve created a form to act as a customer search (by city) with filter tables which gives results of all customers within the same city (along with their ID).
What I want to do is to be able to click on a specific customer ID and have a Macro that copies the ID and transfer it to another form which pulls up all details and purchase history of that specific customer.
Specifically, what I’m looking to do is to take a value from one form, then open another form and pass the value on to it.
Any tips or sample/relevant code on how i would be able to program that into a macro ?
Thanks in advance