Ensure that all required fields are filled in before closing form

[John V]

My Database is coming along nicely, thanks to the people here.

I have come to the next issue in designing my form, however.

The process is this, the user creates a Patient in the database using the Contact Information Form and then they can fill out a form for the Doctors Visit using the Patient Encounter Form. On the Patient Encounter form they have to select the Patient ID Number so the database knows which patient the form is for.

The Patient Encounter Form is made up of 14 subforms for everything from "Type of Encounter" and "Encounter Date" to "Dietician" and "Referrals". The Record Source for the Main form of the Patient Encounter Form is the Contact Information Table. The Combo Box for choosing the Patient ID Number is unbound, with a Record Source that gets the list from the Patient ID Field in the Contact Information Table (PK).

There is a "New" button that clears the fields on all of the subforms and starts a new record on each of the underlying tables. It does not clear the Patient ID choice in the Patient ID Combo Box.

The user can move away from the current record by doing one of three things:
A) Press the "New" button
B) Choose a different Patient ID in the Combo Box


C) Close the form

There are fields is the form that are required. These are Patient ID, Encounter Date, Type of Encounter, and they must make at least one choice in at least one of the other areas of the form (i.e. Targeted Care/CDM, Dietician, Referrals) I have already set the Type of Encounter and Encounter Date to required in the under lying tables. No other fields are set to required in the underlying tables.

I want to check that the requirements for filling in the form have been met before the user moves away from the current record by one of the choices above. How do I do this?

I have attached a copy of my database thus far. I have already created 4 Patients using the Contact Information Form. So please focus on the Patient Encounter Form.

Thank you
John V

Wetaskiwin.zip

[June7]

Options:

1. set the fields as required in the table and let Access nag the users when they try to leave form without entering data

3. code in the form BeforeUpdate event checks if data in required fields and acts appropriately

[John V]

Options:

1. set the fields as required in the table and let Access nag the users when they try to leave form without entering data

3. code in the form BeforeUpdate event checks if data in required fields and acts appropriately

I have tried option 1 and it doesn't work. Also I cant do that for about half of the subforms (and their underlying tables) because not every field is required the user just has to pick at least one of the choices on at least one of the subforms (Tables), but not all of them.

Not sure what the code would be for the other option (I am very new to this) but I will do some research and maybe be back with more questions.

John V

[June7]

The phrase 'user just has to pick at least one of the choices' makes me think the data structure is not normalized. Are these a bunch of Yes/No fields?

The code would be like:

Sub Form_BeforeUpdate(Cancel As Integer)
If Me.checkbox1=0 And Me.checkbox2=0 Then
MsgBox "Must select one option."
Cancel = True
End If
End Sub