Problem with combo box in a form

S

seth

I am creating a form to store data in 8 different tables. I used a query to
join all the tables together, and I am now in the process of placing all the
fields on the form. The first and second tables were fine and everything
works like it shuold on the form. However, after I placed teh fields from the
third form, all the combo boxes were now text boxes. I double checked that
the fields in the actual table were combo boxes. I dont know whats wrong, can
someone please help me?
 
J

John Vinson

I am creating a form to store data in 8 different tables. I used a query to
join all the tables together, and I am now in the process of placing all the
fields on the form.
Click to expand...

WRONG way to go.

It is neither appropriate nor necessary to create one massive monster
query. Instead, consider using a main Form for the "one" side table,
Subforms for the "many" side tables, and combo boxes for the lookup
tables.
The first and second tables were fine and everything
works like it shuold on the form. However, after I placed teh fields from the
third form, all the combo boxes were now text boxes. I double checked that
the fields in the actual table were combo boxes. I dont know whats wrong, can
someone please help me?
Click to expand...

You're yet another victim of Microsoft's misleading Lookup feature.
The fields in the tables ARE DATA. The table does NOT contain "combo
boxes" - which are display tools, not data; the table contains
numbers, which are concealed from your view by the combo boxes.

Rather than using the lookup field type, you can very easily use the
Combo Box tool from the form design toolbox to add combo boxes to your
form. It is not necessary that they be "lookup fields" in your table
in order to do this.

John W. Vinson[MVP]
 
Top