Software

Ask something
Question Locked

MS-Access: How to validate data through double entry

0 helpful
2 replies

by bitswit

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi, I'm a complete newbie trying to grapple with MS-Access. My situation: I have two fields for data-entry namely "Village" and "City". When I input data, I want the Village field data-entered twice in succession, and only if BOTH the entries are correct, should it move onto the next field, i.e. City. Else, it should ask the data-puncher to re-input the Village field. Any help will be appreciated pls - Thnx!

p.s. I do NOT require saving both the inputs. Just need the final validated input in my "Village" field.

2 replies

by tony hopkinson

I know if I got that as a user, it would annoy the heck out of me.

Just make one an unbound edit box.

Personally I'd have a rethink on this, what do you mean by correct, Matching ?

It's about as user friendly as a back scratcher made from a wire brush....

This discussion is closed to new replies.