selecting records

[BMan111]

I am attempting to select a particular record based on its primary field. I have a drop down box will the key value in it (project_number), and when the user selects it, I want it to go to the record with that project number in its key, so I can modify that records Notes value. I, unfortunatly, have no idea how to do this, and a whole lot of you are a whole lot better than I am, so I would appreciate some help.

Anyone?

Brandon

[schlauberger]

On you combo box AfterUpdate Event try the following code:

Me.RecordsetClone.FindFirst "[project_number] =" & Me!cboProjNum
Me.Bookmark = Me.RecordsetClone.Bookmark

[BMan111]

not to be annoying, but could you possibly break that code chunck down and explain what the arugments of it are?

Brandon

[schlauberger]

The RecordsetClone property refers to the forms Recordset object. FindFirst searches through the recordset object for the selected criteria. Each record within your recordset object has a uniquely assigned bookmark. By seting the current bookmark to the searched criteria the focus will move to the searched criteria's bookmark (The RecordsetClone).