Drop Down List

[haazzaa]

Hi all,

I need some help, I have a form that is based on a query which works.

I need add a column (Start Time) in the form based on a table, so that users can select the appropriate value from the drop down list.

Is this possible? I have added the additional column as a list box/combo box, but when i select the time against a specific row, the whole column populates with the time selected.

Help.

Thanks



haazzaa

[pbaldy]

It sounds like the combo is unbound (no control source).

[haazzaa]

Thanks for the reply.

The Values that i am trying to select are from another form and do not live in the underlying table.

That is,

I have a form called "Employees". It has UserID,User, Date.

Using the wizard i create a combo box based on another table.

See attached doco for more info.

Thanks

h

[pbaldy]

I thought you were adding one:

I need add a column (Start Time) in the form based on a table, so that users can select the appropriate value from the drop down list.

If you want to have a value associated with each record, you need a field to store it in. As expected, your combo has no control source, so you will see the same value for every record displayed on the form. In essence you're telling Access "this value isn't associated with a record" when you don't have a control source.