default values in drop list mystery

[Gary]

I created a droplist on my form. I linked it to to a field in my table
called AdHocACCCode and named the droplist AdHocACCCodeBox. The droplist
gets its list from values I typed in and they are saved to the AdHocACCCode
field in the table.

My problem is that when there is a new record the droplist shows a zero
value and will sometimes, but not always, change to a -1 when there are
values in other fields.

The field in the table is formatted as text and is added to the query behind
the form.

Please help.

 

[dcichelli]

Hi Gary,

I think your problem relates to the underlying structure of your
database. In your table, the AdHocACCCode needs to be a lookup field
data type. When you select this data type in the table design view, a
wizard will pop up and walk you through the process. You can type in
the values you want the user to be able to select down the road in your
form.

You see, you cannot have a droplist only in the form without changing
the data type in the table to a lookup field. It makes perfect sense
that Access shows no values for this field when you add a new record.

Sound good?