Gustav Brock
gustav at cactus.dk
Thu Sep 25 11:48:07 CDT 2003
Hi Oleg
Try this, also for the OnCurrent event:
Private Sub ID_AfterUpdate()
Me!Combo27.Value = vbNullString & Me!ID.Value
End Sub
/gustav
> this should be fairly simple, but i dont see it; --
> I made it so I can select value from the combo box, and show it for the
> rest of the controls ---
> Set rs = Me.Recordset.Clone
> rs.FindFirst "[ID] = '" & Me![Combo27] & "'"
> Me.Bookmark = rs.Bookmark
> how do I do it the other way around ? meaning if I go through the form
> using "next", "previous" buttons for comboID field to change accordingly
> this doesn't work
> Private Sub ID_AfterUpdate()
> Me.Combo27.Text = Me.ID.Text
> End Sub