"You can't go to the specified record"

[badabing]

In Access 97, I've got a form that's bound to a table. On the form, I can display previously entered data by use of a list box. I also have a command button for adding a new record. However, after entering a new record, if I want to then choose a previously existing record from the list box, I get a message:
"Run time error '2105': You can't go to the specified record"

In the OnClick event of my list box, I'm using the following code:
Me.RecordsetClone.FindFirst "[SessionID] = " & Me![lstSessions]
Me.Bookmark = Me.RecordsetClone.Bookmark

Can anyone offer advice on what I have to do to get around this type of error? Thank you.....

 

[doran_doran]

dlookup...

I would use dlooiup if its only few fields.

 

[badabing]

Thanks for your reply..... I thought I had my profile's mail set up to notify me of responses, but apparently didn't. That's why I didn't thank you sooner. I'll go modify my profile immediately.

How would the dlookup function work to avoid getting that message? I have about 10 fields that display when a record is picked from the list box. Is that too many for a DLookup scenario?

Thanks again!

 

[Rich]

Save the NewRecord and then Requery the list box