Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Thu Sep 25 10:21:31 CDT 2003
I'd try it in the OnCurrent event. Rocky ----- Original Message ----- From: <Oleg_123 at xuppa.com> To: <accessd at databaseadvisors.com> Sent: Thursday, September 25, 2003 7:52 AM Subject: [AccessD] Another combo box question > Dear List: > > 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 > > > OLeg > > > ----------------------------------------- > Get Breaking News from CNN, ABC, NBC, CBS Now. > http://www.xuppa.com/news/?link=webmail > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >