Go Back   Access World Forums > Search Forums

 
Showing results 1 to 2 of 2
Search took 0.00 seconds.
Search: Posts Made By: Pat Hartman
Forum: Forms 09-23-2017, 05:35 PM
Replies: 13
Views: 1,286
Posted By Pat Hartman
Re: Check Userform entry not a duplicate

Every control on a form has 17 events. If you tab through the form, each control will fire the GotFocus, LostFocus, Enter, Exit, and the key press events. If you modify the value, the Before and...
Forum: Forms 09-23-2017, 06:14 AM
Replies: 13
Views: 1,286
Posted By Pat Hartman
Re: Check Userform entry not a duplicate

Always set the requirement at the table level. This will have the database engine enforce the constraint so it doesn't matter what causes the update. It could be a form, a query, or some action...
Showing results 1 to 2 of 2

 
Forum Jump



All times are GMT -8. The time now is 07:09 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World