Remove drop down menus from my form

[mhshane]

I am trying to create a form based on a query/table that has several Value lists. When I create the form those fields have all the options from the value list. How can I make the form display only the selected item from the list.

MS Access 2007

tblWireless fields: many more fields than listed below but here are the pertinent ones
Wireless (primary key, text)
Name on Bill (text)
Company (text, value list)
Carrier (text, value list)
Problem (Yes/No)
Problem Desc (Memo)

Created qryProblems to show the data fields listed above

frmProblems: I want a form that will display all problems at the same time, not one at a time.

I click on Create-->Multiple Items in the Forms and I get a form that sorta does what I want. A little adjusting and it will be fine. Only problem is the Company and Carrier fields display all the data listed in the table's value lists.
For Carrier I see:
AT&T
Verizon
Sprint

I want to see only the one selected for that particular number.

Any suggestions?

Thanks.

 

[PHV]

Any suggestions?
Don't use value list(s) but lookup table(s)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mhshane]

Thank you for the reply. Not quite sure what you mean though? Can you explain?

Are you saying create a new table for Carriers, new table for Company and then use look up tables?

I have never used lookup tables but that is the only design I can see from your suggestion.

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mhshane]

Cool. I get it now. That gives me the answer to another major question...thank you...but for Company and Carrier in tblWireless I like having the Value Lists. I have another form for creating new entries. In that form having all values displayed and being able to simply click the ones that apply is helpful.

So is there a way to suppress the Controls from displaying all values on a list?

If not then I will figure out another route. Everything is a trade off in Access isn't it?

Thanks again for the link and the lookup tables idea. Extremely useful for my next design.

 

[PHV]

A standard way with ForeignKeys in a form is to use a ComboBox.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886