combo box question

[HandJT]

I have a combo box that lists different values based on a search. I would like Access to display the contents of each record listed in the combo box on the same form. I have in the After Update procedure of the combo box the following code, however it doesn't work. Can anybody tell me what I am doing wrong?

Sub NDW_AfterUpdate()
'Find the record that matches the control

Me.RecordSetClone.FindFirst "[NDW] = " & Me![NDW]
Me.Bookmark = Me.RecordSetClone.Bookmark
End Sub

 

[TheAceMan1]

How are ya HandJT . . . . .

[blue]I have in the After Update procedure of the combo box the following code, [purple]however it doesn't work[/purple][/blue]

The code appears legit. Are you sure NDW of the combobox selection is in the resordset of the form?

See Ya! . . . . . .

 

[HandJT]

Yes and it gives me a runtime error message of 7951: You entered an expression that has an invalid reference to the Recordset Clone property. Not sure what that means and why this code would give me that. Any suggestions?

 

[TheAceMan1]

HandJT . . . . .

Try this:

[blue]   Dim rst As DAO.Recordset
   
   Set rst = Me.RecordsetClone
   
   rst.FindFirst "[NDW] = " & Me![NDW]
   Me.Bookmark = rst.Bookmark
   
   Set rst = Nothing[/blue]

You do realize the code takes no action if the search fails?

See Ya! . . . . . .

 

[HandJT]

Still giving me the same error. I don't know what the problem is.

 

[randy700]

If NDW is text, you need to change this...
Me.RecordSetClone.FindFirst "[NDW] = " & Me![NDW]

to this...
Me.RecordSetClone.FindFirst "[NDW] = '" & Me![NDW] & "'"



Randy

 

[RoyVidar]

Does the form have a recordset (a table or query as recordsource)?

Roy-Vidar