I was hoping for a bit of elaboration on the differences between a control source and a row source. I thought they were/controlled the same thing until I saw this happen.
Thanks for your time
Ben
Adam Schwanz
@Reply 2 years ago
The Control Source is the Field in the table that you are storing the Value From the Bound Field of the Row Source In.
For instance, You could have a Combo box and set the Control Source to CustomerID. You might use the Row Source to be CustomerID, FullName and make the CustomerID width 0. This way when you are selecting from the combo box you are able to see the name values and can pick the name "John Smith" instead of the customerID "14".
The row source is only what you see inside of the control, the control source is the table field that it is bound to.
Benjamin HeacoxOP
@Reply 2 years ago
Adam
I hope your weekend went well. Thank you for this information.
Ben
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 6.
