Stored Procedures and Bookmarks

  • Thread starter Thread starter Davy
  • Start date Start date
D

Davy

I have a main form that is based on a StoredProcedure and
I am adding information to the table on which the
StoredProcedue is based via a button (the button opens
another form). I know what the bookmark is within the add
form but I need to display the bookmarked record in the
main form after closing the "Add form". Temporarily I
stored the bookmark in a form that is constantly open and
not accessible to the user but I don't know what to do
next. Remember that the main form is based on a
StoredProcedure (filtered by the userid).

Advice will be greatly appreciated.

Thanks
Carlos
 
Davy said:
I have a main form that is based on a StoredProcedure and
I am adding information to the table on which the
StoredProcedue is based via a button (the button opens
another form). I know what the bookmark is within the add
form but I need to display the bookmarked record in the
main form after closing the "Add form". Temporarily I
stored the bookmark in a form that is constantly open and
not accessible to the user but I don't know what to do
next. Remember that the main form is based on a
StoredProcedure (filtered by the userid).
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bookmarks are only relevant on the same recordset. If, as you say,
there is a related column value in both recordsets (UserID) you should
use that instead. If there is more than one column value that indicates
a unique record in both recordsets, use those column values to reference
the record in the other recordset.

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQGIsdYechKqOuFEgEQIC4gCg8iSQw6nH+y2G4aLGLddBs0KiSjkAoPvS
4bMkWi6Jz6Njs/AjoXx5zqH8
=mBdA
-----END PGP SIGNATURE-----
 
Back
Top