Index/PK Cannot Contain Null Value -only in form, not query

[bsnalex]

Now this is odd.

I'm hitting a hurdle on the first form in my DB. In the back end there's a bunch of tables, however all are connected via the field "RGID". It's the PK in the main registration table (patient name, dob, address, etc) and links 1-to-1 on the further tables (Diagnosis info, referral info, General Practitioner, Dentist, etc). The query I've built to create my registration form takes the registration table, and then brings in the fields from the further tables to fill in on the form.

Now, the registration form itself is located in a subform within the main registration form. My goal is to have the registration data on one Page (tab), then page 2 is surgical histroy, page 3 is appointment history, etc. The record filter for the subform (which contains the registration query) is therefore based on the active RGID within the main form.

The problem is this: I can update the records with no problem when running the query itself and manually typing in the data into the query. When I bring that query into the form, however, I receive the "Index or Primary Key Cannot Contain Null Value", after adding data to fields that would update the further tables mentioned above.

It's worth noting that in the back-end, all tables linked via the RGID field have referential integrity enforced.

Anyone got any ideas?

 

[ranman256]

Before you can add subform data, you must save the primary parent record.
you cant add client surgeries, unless the CLIENT is saved. You may have data in the screen , but did not click the save (the pencil).
Once the pencil has turned to arrow. The record is saved and the clientID (autonumber?) will appear. NOW you can save subform data.

 

[bsnalex]

Before you can add subform data, you must save the primary parent record.
you cant add client surgeries, unless the CLIENT is saved. You may have data in the screen , but did not click the save (the pencil).
Once the pencil has turned to arrow. The record is saved and the clientID (autonumber?) will appear. NOW you can save subform data.

The parent record was preexisting.