DEFAULT VALUE IN COMBO BOX

[acss]

Tried searching yet i and cant find the solution of having one of the five
selections (CustomerID)in my combo box be the default value when the opening
a new record on the form. I have tried the default properties yet when i go
through the records the new record remains blank unless i select it. The
details-row source type table/query, select distinct and is bound column
1.Any help is appreciated.

 

[Ken Snell]

What value did you use for the Default Value property? It needs to be the
value of the Bound Column, not the value of the first visible column
(assuming that the Bound Column is hidden from view).

 

[acss]

Hello Ken,
Not sure where to see the bound column i just see a numer 1 in the
properties as bound?

 

[Ken Snell]

The 1 means that the first field in the query that provides the data to the
combo box is the bound field.