I have two tables structured as:
I have two different forms for each of these tables and would like to add two buttons to the Personal Information form that link to the Referral Information form. Once the info is filled out in the personal info form I would like it to open that person's existing record in the Referral Information form for editing in button #1 or allow for the creation of a new record for Referral Information in button #2. I am fairly new at access so I'm not sure how to accomplish this. I have inquired about this and someone told me that it is passing paramaters but I'm not sure what that is.
- Personal Information (includes first name, last name, pesonal ID, and DOB fields)
- Referral Information which includes first name, last name and personal ID fields (looked up from the Personal Info table) in addition to a from field, to field, and date field