Yes/No field

[Gigi0614]

Hi!
I am trying to setup a Yes/No field as a control on a form.

I have 2 tables patientInfo and scheduledSurgeries.
On the patientInfo table, I have a YES/NO field called "coveredByInsurance".

How can I create a lookup field on the scheduledSurgeries form that would take the patientID from scheduledSurgeries and do a lookup on coveredByInsurance.

Can I set this up as a control, or would it have to be a subform?

 

[PHV]

=DLookUp("coveredByInsurance", "patientInfo", "patientID='" & Me![name of patientID control] & "'")
If patientID is defined as numeric, get rid of the single quotes.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244