Accessing Access database in the VBA form

[Guest]

Hi,

I have a form in which i have a combo box and a comand button.
Now based on the values selected in the combo box, i need to "update" a
field in the access table. The form and the access table are not linked.

Please let me know how can we do this?

 

[Pieter Wijnen]

With limited info givven:

Private Sub Cmd1_Click()
CurrentDb.Execute "UPDATE myTable Set Myfield1=' & Me.combo1.Value & "'
WHERE MyField2='" & Me.combo1.Column(1) & "'"
End Sub

Pieter