I have a patient form that is controlled by a parameter query. The user must enter the ID of the patient to display that patient’s particular file.
Once the patient form is opened to a particular entry there is a “Edit Patient Referral” button. Once the button is clicked I would like the patient referral information form to be opened to that patient’s referral information (which is controlled by the patient referral info query). If a referral does not exists for the patient I would like a message box to state that a referral does not exist.
The two forms are linked by the customer ID and each patient referral has its own referral ID. I know access provides a button to open a form to a selected record by criteria but it does not account for records that do not exist.
I have not done much programming or coding so I’m not sure how exactly to do this. I was thinking of starting with a lookup to see if a record exists by the referral ID in the patient referral info query but am uncertain how to execute this.
Any insight would be great!