Frm field ControlSource based on values of two Tbl fields

[DubCap01]

Hi all,

I am trying to create a lookup of sorts to populate a form field. Not sure of the syntax, hence the question...

TblBookings (we'll use the three fields for simplicity sake)
BookingID
CheckedIn (True/False)
CheckedOut (True/False)

The ControlSource for the Form field should be the count of records in TblBookings where CheckedIn = True and CheckedOut = False

I can get the answer in a query, but not sure how to write the syntax for the form field ControlSource

thanks in anticipation!

Pete

[pbaldy]

You should be able to use DCount() with the same criteria.

[DubCap01]

Yep, that worked Paul, thank you!

[pbaldy]

Happy to help!