Desktop

Ask something
Discussion Locked

MS ACCESS 95

0 helpful
3 replies

by mruiz

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Have a form with fields unbound. On the same form I have a button that appends data to two different tables. Need msgbox to appear when record a is duplicated. The table doesn't get updated if there a duplicate record but It would be nice to havemsgbox appear. Need help with this.

3 replies

by research

You could store the number of records of the table in a variable. Then after your event (update) compare the number of current records to the stored variable. If they match, you can then display your msgbox.

This discussion is closed to new replies.