Can we have a combo box in the tables?

[Guest]

Hi,
I was trying to use a Combox box inorder to avoid repetitive entry of the data.Can we do that?If so please explain

Thanks in Advance.

 

[Phil Carrero]

You can do that in the design view of the table.
When you select the field you want a combo box in, choose the LookUp
Wizard from the drop down list on the Data Type property and follow the
prompts.
Otherwise you can do it manually down the bottom if on the Lookup
tab you select "Combo Box" and define type, row source and columns.

But this won't convert text fields in forms already designed unless
you delete them and insert them new from the Field List (which takes the
type straight from the table you designed/modified.
Alternatively you can make a new Combo Box on the form to look up
values from another table whilst leaving the table's field untouched...

Phil

Hi,
I was trying to use a Combox box inorder to avoid repetitive entry of the
data.Can we do that?If so please explain

Thanks in Advance.

 

[Douglas J. Steele]

Before you use the Lookup Wizard, though, be aware that most developers
consider it to be an extremely misguided "feature" in Access. Check out
http://www.mvps.org/access/lookupfields.htm at "The Access Web" for a
discussion of some of the reasons why.

Realistically, you should never be updating a table directly, but should
always use a form. Once you've got a form involved, it's pretty simply to
add combo boxes.