combobox not working on the form

[sibbbra]

hi
combobox not working on the form.
The attached Db has a form customers. I cant enter anything. Any help plz !

 

[June7]

It is bound to Type_ID autonumber field from Customer_Type table. Cannot enter data into autonumber field. This field is automatically populated by Access.

Set form RecordSource to Customers table, not query.

Then bind combobox to Type_ID field in Customers.

Set combobox RowSource to: SELECT Type_ID, Type_Name FROM Customer_Type ORDER BY Type_Name;

This is why it is not a good to use exact same field name in multiple tables.

 

[arnelgp]

The attached Db has a form customers.

there is no form on the db.

 

[Gasman]

there is no form on the db.

Need to set to All ACcess Objects Arnel. For some strange reason the O/P only had Tables?

 

[arnelgp]

Need to set to All ACcess Objects Arnel. For some strange reason the O/P only had Tables?

thanks. now i see the form.
to the OP, remove the Customer_Type.Type_ID from your query ("Customers Names" query) or
entirely remove customer_type table, then it will work.