update table from combo box

[bjgdal]

I am currently trying to create an application which will help me in my work. To do this I need to update a field called "Installations" in a table with the same value for all records. The value however is from a list of about 1300 military installations so typing in the value in an update query is not optimum.

I am able to get a combo box in a form to bring up the list and to get a parameter query to come up (after selecting the appropriate item in the list) which has the value in it but don't know how to get the table to update. I'm wondering if an AfterUpdate action is needed as a combo box event rather than the query. Not really sure here...it's been many years since I've taken a VB programming course and I really don't use it much..my work is mostly in Access but without much programming needed. Any help appreciated.
Betty

[developing]

if everythings in the same table then oyu can use the bookmark property....a relaly quick way is to put the following in the combo box's after update event

 Me.RecordsetClone.FindFirst "[respective field in the table] = " & Me!cboComboBox]
        Me.Bookmark = Me.RecordsetClone.Bookmark

ps: depending on the field type of the column, you might have to use different formatting where the following is concerned:
"[respective field in the table] = " & Me!cboComboBox]