Oleg_123 at xuppa.com
Oleg_123 at xuppa.com
Thu Sep 25 12:03:35 CDT 2003
nope, the value in combo box doesn't change; stays exactly the same... > 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 > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com ----------------------------------------- Get Breaking News from CNN, ABC, NBC, CBS Now. http://www.xuppa.com/news/?link=webmail