I couldn't test because the file you posted has linked tables, which obviously don't work for me. What's the data type of the AFRNumber field?
I couldn't test because the file you posted has linked tables, which obviously don't work for me. What's the data type of the AFRNumber field?
Hi
Put a space Before and After the = sign
The AFR Number field is set to 'Number' in the table.
I put a space before and after the = sign and it didn't help.
Here is the version before splitting the database.
Hi
This works
Thanks Mike it does work but can the field (or is it "control"?) be cleared if the number exists so the user can try again?