Combo box on Continuous form updating current record only

[Minddumps]

Hey everyone,

Something I've researched online and was unable to find a solution for. I played around with it and this is what worked for me:

Combo box on continuous form should have the control source listed as the field on the form that will be updated. The Row Source, however, is a query that includes 2 things: the field on the form that will be updated (this part will be nonvisible in your form) and the table/query of selections you want to show up in the combo box (visible). Then ensure the Bound column is set to 1 and the Column count is set to 2 with Column Widths as 0";1"

 

[boblarson]

The Row Source, however, is a query that includes 2 things: the field on the form that will be updated (this part will be nonvisible in your form) and the table/query of selections you want to show up in the combo box (visible).

The Row Source of the combo box should ONLY contain the id/values from the lookup table. It should have no association with the form (except possibly to have criteria referring to that form). The form's record set should be where the selections, inputs are saved. But the row source of the combo should not be using the table that the form is based on.