Need Help

[ernie]

Hi all,

I need help validating input mask in a single field on a form.
my input mask in the field "Ref#" is 000/00

the first three digits "000" represent the number of entries for the day and
the last two digits "00" represent the day.

example:

003/11 would be the 3rd entry for today.

I need help validating the entries so that the user dont skip numbers. for
example if the last Ref# was 003/11 then the next Ref# would be 004/11. i
want to create code so that, if the user enters something like 005/11 instead
of 004/11, the user will be warned with an error message asking to put in the
correct Ref#.

Better yet if i could get codes to create the next Ref# instead of letting
the user entering the Ref#

I appreciate your help
Thank you

 

[Jeff Boyce]

Ernie

Consider stepping back for a moment....

What it sounds like you are trying to do is stuff two facts (# of entries;
day) into a single field. This is not good database design.

Can you use one field for each fact? You might find it easier to test what
the previous "high" values were when you can look at each independently.

In fact, you might not need to force the user to "remember" and enter the
next one -- have you looked into having Access provide the
"next-in-sequence" value as a default?

Regards

Jeff Boyce
Microsoft Office/Access MVP