Maintaining Selections in Combo Boxex within Forms

[rodgo]

If I have a form with several combo boxes within it, how can I keep the selections I have made in the combo boxes next time I open the form?

 

[bat17]

It depends on what you are doing, the simplest method would be to bind them to a table behind the form but if the form is already bound for data then this wont work.
You will probably need to create some code to update a table on the After Update Event of each box, and have code on the form open event to set them initialy.

Shout if you need more help setting it up

Peter

 

[rodgo]

How would you set it up to update a table using the AfterUpdate function?

 

[SydneyGeek]

Dunno -- this may be left field, but you could try writing the combo values to their Tag properties and then reading them back.

Denis

 

[bat17]

I don't think that writing to Tag properties would be stored between sessions. to do it from the comboBoxes Create a table with just one record in it which has the values you want for the comboboxes.
behind each box add code to the after update Event

Sub Combo1_AfterUpdate()
Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset("tblCombos")
With rst
   .Edit
   ' Change data in edit buffer.
   !Field1 = Me.Combo1 
   .Update
   .Close
End With
Set rst = Nothing
End Sub

where tblCombos is the table holding the data for your combos. Field1 is the field containing the data for that combo.

in the Open event of the form you need something like

Private Sub Form_Open(Cancel As Integer)
Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset("tblCombos")

With rst
   .MoveFirst
    Me.Combo1 = !Field1
    Me.Combo2 = !Field2
    Me.Combo3 = !Field3


End With
Set rst = Nothing

Hope that makes sense

Peter