AccessApprentice
Programmer
OK, I'm trying to find a way to get my form to move to the existing record in my database. The key I'm using is one I created called "Item Number" (not the default AutoNumber ID field). When someone types in (or selects) a value in the Item Number combo-box, I'd like for the form to either 1) go to the appropriate record for editing, if it exists, or 2) start a new record. I'VE TRIED ALMOST EVERYTHING...even the infamous:
Me.RecordSetClone.Findfirst "[Item no] = "& Me![Item no]
Me.Bookmark = Me.RecordSetClone.Bookmark
I cannot get that piece of code to work...I wind up generating one error or another, or when it DOES run it doesn't work properly. And I've even tried a few others. I'm using Access2000, for those who might want to know version numbers.
If anyone has a RELIABLE way to get this form to work, I'd appreciate it! THANKS!
Me.RecordSetClone.Findfirst "[Item no] = "& Me![Item no]
Me.Bookmark = Me.RecordSetClone.Bookmark
I cannot get that piece of code to work...I wind up generating one error or another, or when it DOES run it doesn't work properly. And I've even tried a few others. I'm using Access2000, for those who might want to know version numbers.
If anyone has a RELIABLE way to get this form to work, I'd appreciate it! THANKS!