DlookUp

[Cdogg]

I have a query looking up Yes Or No Check box using LastName, FirstName, ChildsName, Date, and getting the information from 4 textboxes on my form. After I enter the information I would like the checkbox on my form to show yes or no in that record. I ran the query and it works. But I can't get Dlookup to look it up and put it in the checkbox.

Tank you for your help

 

[Fizzio]

It sounds like you are using an unbound form with unbound text boxes??
If so, set the forms recorsource to the query, and add an (invisible if you like) ID field and a bound checkbox control to the field that has the yes/no data in it. either use a button to run the query or on the after_update / lost_focus event of the last field in your 'lookup' set.

Hope this is clear and what you are looking for!