I have an issue where I am trying to link records to a specific record. So when you click on the record in an access form, it should open up the form with that record.
Now I have to mention that the field with the criteria is a text ( I had to do a text rather then a number for specific reasons)
I created a macro which runs onclick and I have attached the picture of what the macro shows. I have done this several other times.
However, when I click on the field with the onclick action it gives me a "data mismatch criteria error"
I know both fields are text. Does access maybe convert one field into number? is there a workaround it?