Launch new record child form with 2 foreign keys pre-populated

[Awesome!]

Hi,

I am building a database which has a main table that contains patient demographics and then child tables which contains clinic visits. There are many kinds of clinic visits (TB, HIV, CD4, VL) so I didn't use subforms in this case.

I managed to create several buttons on the main demographics form that open a pop-up child form to a new record and linked to that patient.

There are two IDs that I am working with. One is a national ID (NID) and one is an ID we have created internally from my organization (OID). There is always a unique OID for the patient but not all patients have a NID.

When I open the child forms I get a blank NID and OID. I would like in the new record for the NID to be prepopulated with the associated/blank NID in the parent form and then do the same with the OID.

It would be good if the data encoder accidentally clicks the button to the child form, that the pre-populated fields won't keep the record with the remaining fields blank (I get this kind of error when pre-populating fields in Epi Info).

How would I go about coding this?

Thanks,


Awesome!

[June7]

Two things you want to happen and both are fairly common topics:

1. pass data to the opening form - several ways to do this, one is code in the opening form that refers to the main form - however, I don't see need to store the NID into the dependent table.

If Me.NewRecord Then
Me!OID = Forms.mainformname!OID
End If

2. give user opportunity to cancel the record - since you require every field to have data (except NID), one way is to set every field as required in table, then Access can nag the user if they screw up, otherwise, code in the form BeforeUpdate event would have to check every field for data and if any one is empty, take appropriate action
https://www.accessforums.net/program...put-48582.html