Add to combo box list

[Bradon]

I have a form that contains a field [forename] that I want to add to an existing combobox.

I only want the one name that appears on the current record to appear in the combo box.

any suggestions?

 

[bat17]

why use a combo box if yoy canot make a choice from it? just change the combo box to a text box.
Right click in design view and select change...

Peter

 

[Bradon]

the cobo box has a list of items drawn from another field i.e he, she, him, her....

I want to add the forename to this list and the user select the choice required for their work.

 

[bat17]

The only thought that come to mind is to create a query that would just pick up the relevant name, use a union query to join your original data to the name and then base the Combo on the union query. You would neeed to requery the combo whenever the record changes though.

Peter