I created a value list combo box through the the lookup tab of the field properties in the design view of the table. I chose "List Box" for Display Control; "Value List" for Row Source Type; and then entered my values between parenthesis and separated by a semi-colon (ex. "referral";"email blast";"internet search") in Row Source. Is this the same thing as going through the wizard? If not, how does this compare to using the table based combo box in regards to updating it? It seems easier to create than the table based box and updating is a matter of just going into the properties and updating the "Row Source."
Hope I'm not jumping ahead, just finished all 9 levels of Beginner.
Thanks for your response
Reply from Alex Hedley:
I'd stick to creating a separate Table with its own rows that you then base a combo on. This means it can be used in multiple places and gives you more flexibility for amendments. Also if this has been added into the Table itself as a Lookup These can cause you issues further down the line with relationships etc
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 Beginner 8.