Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Access
Microsoft Access Forms
Ensuring values in a subform are entered correctly
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="John W. Vinson, post: 10470154"] Open the Relationships window and create a one to many relationship from EmployeeManNotbl to EmployeeInsptbl on the ManNo field; check the "Enforce Referential Integrity" checkbox. If you have that relationship set, you cannot put in an invalid ManNo - you'll get an error message. You can also use a Combo Box on the subform; the subform should be bound to EmployeeInsptbl, using ID as the Master/Child Link Field. The subform should have a combo box with its Limit to List property set to Yes, based on EmployeeManNotbl. The combo can display the ManNo, or the name, or a combination of fields - whatever is most meaningful for your users. John W. Vinson [MVP] [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Access
Microsoft Access Forms
Ensuring values in a subform are entered correctly
Top
