Search results

I'm currently using the Order Entry DB and am having a problem setting a default value for the EmployeeID field in the frmOrders. The user only has one employee that sells tickets and would like to be able to have that employee's name automatically appear in the combo box each time she enters...

I'm currently using a DLookup for a form so that the user can't enter a duplicate customer record. Normally it works fine, but when I try to enter in a name with an apostrophe (i.e., O'Neill or O'Donnell), I get an error message. Can anyone help me with this? Here's the code I'm using...