DLOOKUP Always Returning First row of Control Table

[Caleeco]

Hello,

I have a table called BookingsT, which will represent a seating plan in my office.

I have created a front end form which will display records and allow users to enter their name to update BookingsT (I dont know how to do this yet )

However, step 1 is reflecting the current BookingsT to the form, i read online that DLOOKUP can be used. This is the formula I created for Seat1 textbox

=DLookUp("BookingName","BookingsT","BookingSeat=2" And "BookingDate=#" & [tBookingDate] & "#")

However, the first record is always returned. In this case, Seat 2 on 30/10/2020 should return Bill Gates.

What have i done wrong here?

Your help would be much appreciated
Cheers
Caleeco

 

[welshgasman]

Ah! It makes sense now that you've said it. These quotes can be tricky!

Thanks for fix!

I *always* put my criteria into a string and use that. That then also allows me to Debug.Print it to make sure the syntax is correct.