hey everyone, well my titles not exactly right as I'm using Elookup but same syntax, potato-Potatoe
heres my syntax
I'm trying to use 2 textboxes as criteria, the code works with the first one but I get a type-mismatch error when I try to bring in the 2nd criteria. The first field "Tested" is a date/time field but the textbox it uses is already formatted for dlookup (#1/1/2014# format). The 2nd field is just a text field that matches against another textfield. Where am I going wrong with my syntax? thanks!Code:Me.Text33.Value = ELookup("Response", "[Radio Testing]", "Tested = " & [Forms]![Radio Switchboard]![Text32] And "Facility = " & [Forms]![Radio Switchboard]![Combo10])