Mark records to view later

[gottaski]

Can anyone help me figure out the best way to mark records to view later. (I am using Access 97 as a front end to a SQL Server db)

Scenario: I have a form that allows the user to dynamically generate a sql pass-through query. Users hits enter -- query results are displayed in another form. I want the user to be able to mark the records, returned by pass-through query, to view @ a later time.

Any suggestions?

 

[DougP]

If you add those records to a new table then have one extra field which is a "Yes/No". Then allow them to check a box which is that "Yes/No" field.
A query would bring those records back. And a link to the SQL table would allow them to change the data in the SQL db

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive