I have two forms which contain entries which have an AutoNumber field, the tables and hence the forms are not related. Both the AutoNumbers have a format associated with them so when the user sees them in the form they look like:
ABC001 0r XYZ001
Both forms also have a date in them. I have...