I can't get other fields to refresh when using dropdown list...help

[Jakobud]

I have a few different fields in this data access page. I have the little navigation bar in there with the goto next/prev/last/first records. And I also have a drop down list in there where I would choose what record I want to edit. Anyways, using the navigation bar, clicking 'next' over and over, everything refreshes fine. The current line of the dropdown list changes to the next one, and all the other fields on the page change to display the appropriate information for that record. But when I try to click the dropdown menu and select a certain record in there, none of the other fields on the screen update to display the right info...can anyone help me out or point me in the right direction? Thanks!

Jake

 

[fmbpcsup]

To make your picklist change records you can do something like this. Just change the names of the controls and fields to what is used on your form:

Sub combo1_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[ID] = " & Me![combo1]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

 

[Jakobud]

Oh geezz.....you TOTALLY lost me, fmbpcsup. I am definately a beginner at Access and I don't understand where to stick that code at all. Can you (or anyone) be more specific for me? And by the way, note that this is a data access page, not a form. Not sure if that changes anything. Someone PLEASE help me

jake