I have a form that my guys input into. I put 2 command buttons on the switchboard one for new data and one to edit old data. For the edit data form it has the query with a criteria box where it asks for the primary key of the table (ex. K6-003-2015). If I put that into the box the record comes up for editing but when I have this data in my primary key (ex. K7-003-2015A) nothing comes up. There is an input mask involved which is A0\-000\-0000C. Im not sure if that has something to do with this problem. It is a text field. Any comments or thoughts on what may be the issue.
thanks for any help