Lesson 3: 11:33 Why does the criteria for DLOOKUP have to be
"EmployeeID=" & [SalesRepCombo]
instead of
"EmployeeID=" & [SalesRepID]
In other words, why do we use the LABEL (SalesRepCombo) instead of the FIELD NAME (SalesRepID) ?
Kevin Robertson
@Reply 4 years ago
The Combo Box is named SalesRepCombo. The ID is in the value of the Combo Box (the first column).
Scott Axton
@Reply 4 years ago
why do we use the LABEL (SalesRepCombo) instead of the FIELD NAME (SalesRepID)
You could use SalesRepID as the name of the control. The reason we name it "combo" is as an indicator of what type of control it is but also to help you remember, for programming, that there are other fields (usually) that can be utilized. Also the combo box has different properties than say a text box or label.
The name is really not significant. You could just as easily name him George
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 10.
