Linking 2 forms with Command Button

[GarrynGirl]

Hi
Newbie here so please be gentle.
I apologise if this has been previously asked. I did try searching but in a world of confusion.

My question is this:


I have a main form - Patient Data - which I want to link a 2nd form to - Medications. I want the Patient MRN (patient unique ID), the Patient first name, Patient surname and date of birth to automatically come across from the Patient Data to the Medications form.

I have tried to set up using a Command Button linking the unique field MRN but when I click on the Command Button (which is placed in the Patient Data form) to open the Medications form no data appears.

I have tried using youtube videos and have followed exactly but still no data appears. What can I do so that the same data appears in both forms?

Thanks for any help. I know this is probably a very simple fix but not so easy when it doesn't work!

Using Access 2013 on Windows 10.

[Welshgasman]

I would use the OpenArgs argument on the open method of the form and parse that data out when it is received in the Medications form.
You could also just pass the ID and look for the data again, by setting the recordsource?
You could also have a subform for the medications, automatically linked by your ID.

Lots of different ways TBH, depending on how you choose to do it.?

Also make sure that the Medications form does not have Date Entry set to Yes (as that is append mode only).

[GarrynGirl]

Thank you, I will try those alternative methods but shouldn't it just display the data by using the command button as it is intended to link the forms?

[Bob Fitz]

I have a main form - Patient Data - which I want to link a 2nd form to - Medications. I want the Patient MRN (patient unique ID), the Patient first name, Patient surname and date of birth to automatically come across from the Patient Data to the Medications form.

Can you confirm that you have a field called "Patient MRN" in both the Patient Data table and also in the Medications table.

[GarrynGirl]

Bob, yes the Patient MRN is in both tables, as a unique key field.

[Welshgasman]

As a separate form?, No.

You can also open the form with the Where argument, but essentially YOU have to tell the form what record you want, unless it is linked in it's properties.?
Thinking about it further, the Where argument would be a better solution?

[GarrynGirl]

I thought the Command Button would link the data using MRN<>MRN?

[Welshgasman]

I thought the Command Button would link the data using MRN<>MRN?

Not even sure the wizard will do that.?

However computers are stupid and will only do what you instruct them to do. Get it wrong, and they will not say 'oh I know you meant this', they will just ignore you, or give you an error message.

Review the Northwind example that comes with Access.

Also you need Form2.MRN = Form1.MRN ?

[GarrynGirl]

Haha stupid computers. Yes I had my Form2.MRN=Form1.MRN around the wrong way. Thanks for all your help.

[Gicu]

Looks like you solved it but just to make sure I hope you do not have the other fields you mention in your original post (patient first name, surname and DOB) in both tables as that would go against the rules of good database design (normalization).

Cheers,