[AccessD] Another combo box question

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
> 


More information about the AccessD mailing list