S
Steve Haack
I am new to Access, and I am having a bit of trouble getting DLookup to work.
Here is the scenario:
I have a modal form, which is asking the user to enter an ID Card Number,
and then I do a search to see if there is a Player with that card number in
the system.
I want to use DLookup to do that search, but I am getting all sorts of
errors. I think it might be a type mistmatch, but I'm not sure.
The table I want to search is called tblPayers, the field that I want to
search is called PlayerCardID, and it is a text field, but the contents is a
number, like 1001, etc.
Can someone please help?
Here is the scenario:
I have a modal form, which is asking the user to enter an ID Card Number,
and then I do a search to see if there is a Player with that card number in
the system.
I want to use DLookup to do that search, but I am getting all sorts of
errors. I think it might be a type mistmatch, but I'm not sure.
The table I want to search is called tblPayers, the field that I want to
search is called PlayerCardID, and it is a text field, but the contents is a
number, like 1001, etc.
Can someone please help?