Required field

[vangx222]

Is there anyway to make a field on a form required BEFORE any data can be entered into the other fields? I've been having a pop-up message as a reminder, but that gets really annoying because it pops up EVERYTIME I open the form.

Ex. I have a database based on Patients, Patient Visit Date, and Patient exam results. If I DON'T enter in the Visit Date first and start entering data into the exam result subforms first, the data DOES NOT relate to the patient.

However, if I enter in the Visit Date FIRST, then it DOES relate to the patient. Kinda weird, I have no idea where the missed relationship is, but I just thought that maybe if I made the Patient Visit Date required first then that would be ok for now.

Help anyone?

 

[PHV]

Set the [Patient Visit Date] control to required and set the focus to it in the Current event procedure of the form.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886