Drop down menu

  • Thread starter Thread starter Sharisse
  • Start date Start date
S

Sharisse

I am trying to add a drop down menu for States in my database design. How do
I do that? I am very very new to access. I am using Access 2007.
 
Combo boxes are used on forms for selecting values from a list. Forms are
used for data entry. Tables are used for storing records. A "database" (MS
Access) is a file that can contain tables, queries, forms, reports, macros,
code,...
 
Create a new table to hold all the states. tblStates. You shouldn't need an
auto number field as each state should be unique.

In the relationships view, create a relation between the 'states' field of
tblStates to the field in the table that you want to store this data. eg. If
it's to store a customers state, in the table that holds the customer's
details you want the relation to be on the field that holds the customers
state. (1 to many relationship as one value in tblStates will be mapped to
more than one customer).

In the form you want to enter this data, draw a combobox whith the wizard
button on. It will ask you where it should get the list of values from,
select tbleStates. It will ask you what it should do with the selection,
select store in table and then select the field in the customers table that
hols the state data.

I'm making alot of assumptions about your database with this solution. All
this is in the help file which should be your first port of call. This is
basic stuff, please attempt to find the answer next time before asking.
 
Back
Top