BASE: Macro to take a value from one form and insert into another form

[TiiDub]

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

[Ratslinger]

Hello,

In the following post, have two samples doing what you ask. One uses global variables and the other samples accesses the information directly. The process has multiple functions. One to open details of a selected record and the other to open details as a new record. See:

Base macro that opens a new/clean record in another form