Rich,
Your problem may be similar to one I was having. Try the following:
=REFRESH()
GO RECNO()
HTH
>Bob,
>
>Thanks I just needed to be slapped! Well, I was trying to get the ID value that was generated by my Stored Procedure code back into my View record.
>
>It doesn't retrieve it from the Refresh(). So I was doing a Requery() as well but retrieves all records again since currently I am pulling in all records for Local Views for single table edits. I am contemplating one record for the future but I will have to change all of my navigation code to support it in my forms.
>
>How should I get back my new ID that was generated?
>
>TIA
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.