Customer Id on Form - Microsoft Access Expert 3


	Back to Access Expert 3 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Customer Id on Form

Tom Iversen

27 hours ago

In Expert 3, Level 2 you (Richard) @ ~15:55 said that "we need the Customer ID on this form" in order to add a Command Button to open the Customer Form. You further said that it could be made invisible, which you did via the Property Sheet format. Why does the Customer ID actually need to be placed on the Form? I mean, it's just a Form. Is not the ID being in the Query/Table control source enough?

	Lisa Snider @Reply 24 hours ago
In order for Access to know WHICH customer you wish to view when you press the command button, it needs to know WHICH customer is active on the record you are viewing. Placing the customerID field on your open form identifies the customer.

	Kevin Robertson @Reply 23 hours ago
In older versions of Access, you were required to have the ID on the Form. In modern versions, this isn't always the case.

	Alex Lewis @Reply 21 hours ago
The ID was usually put on the form if you were referring to the ID from somewhere else, like a query or VBA code. Like Kevin says, it’s usually on a case by case basis.

Next Unseen

New Feature: Comment Live View