[AccessD] Another combo box question

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



More information about the AccessD mailing list