Cool, I was able to get the control to change the form fields to the information pertaining to that person. Now I have to figure out how to add a new record-set. When I hit the add new record button on the bottom it wont let me add a new name. Ill Google that and see what I am missing. Thanks for the help Jerry.
On 8/18/2010 6:11 AM, Jerry Barnes wrote: > > You will need to go back to your source for the combo box and pick a sort by > field. Note that the source can be a hard query, meaning one that is saved > and that shows up in your query tab or a dynamic query that shows up only in > the source field. Just pick the appropriate place. > > The jumping to a record is possible and easy, but . . . > > > > I don't have access on this computer so I can't look at the code. > > > I am getting ready to go to work. If no one has posted the code by the time > I get there, I'll post it. > > Or you can try this link. > > http://allenbrowne.com/ser-03.html > > It has code that goes in the after update event. > > > Here's the code from the link: > > Sub CboMoveTo_AfterUpdate () > Dim rs As DAO.Recordset > > If Not IsNull(Me.cboMoveTo) Then > 'Save before move. > If Me.Dirty Then > Me.Dirty = False > End If > 'Search in the clone set. > Set rs = Me.RecordsetClone > rs.FindFirst "[CustomerID] = "& Me.cboMoveTo > If rs.NoMatch Then > MsgBox "Not found: filtered?" > Else > 'Display the found record in the form. > Me.Bookmark = rs.Bookmark > End If > Set rs = Nothing > End If > End Sub > > > > > J > > - > > Experience hath shewn, that even under the best forms those entrusted with > power have, in time, and by slow operations, perverted it into tyranny - > Thomas Jefferson on government ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:325388 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm