Hi,
I've got a macro set up so that when the button in a form (showing info about a record) is clicked, it takes the user through to another form where more information tied to that record is. The button works fine, but at the moment it is just showing a random record in the next form when clicked. I want it to be tied to the record that exists in the first form.
Context:
The table of data tied to the first form differs from the table tied to the second form, but they are linked.
Hope that makes sense. In essence, I need record data to flow from one form to the next.
Thanks in advance