Combobox

[jakobt]

Having a form with an order from a order table.
I placed a combobox to lookup and enter the customerid in the order table.
Preferable I would like customer ID to be saved in the order table, but customer name to be looked up in the combobox.
The format of customerID field in the orders table is a number.
The sql in the combobox is select customer.name ; customer.id from customer and the control source is: customer

Now sometimes the customers are showing in the combobox. However sometimes they dont appear in the combobox? Often if I go to design view and back to form view the customers reappear in the combobox??

 

[ranman256]

customer ID SHOULD be in the order.
The combo is a query from the customer table.
It may need refreshed if the customer is newly added.
CboBox.requery

 

[Micron]

customer.name ; customer.id

reverse them and make the bound field the first one, set it's width to zero and then only the name will show but the id value is what gets saved.

control source is: customer

I don't see how this is possible. The control can be bound to a field, not a table. You said the field name is 'name', which btw is a reserved word and you should not use it for object names. See

Microsoft Access tips: Problem names and reserved words in Access

List of problem field names and reserved words in Microsoft Access and JET

allenbrowne.com