View Full Version : Easy seek?


steve711
05-08-2004, 07:11 PM
I have a form that pilots enter data onto. However if they should make a mistake I need to add a search function to allow them to go back to that date with their name and correct the mistake.

For example. My blank entry forms opens. They enter the stuff.
Tomorrow they realize they made a mistake.
I would like to add a new little form with their name and the date of the error (they enter this stuff of course)
then my original (normally blank entry form) loads with their info in it allowing them to correct the error they made.

I have been using seek for other things but can't seem to seek on two criterian. Can someone point me in the right direction? A little inspiration is needed.

PS I accidentally posted this in Macros...

Friday
05-09-2004, 06:10 AM
What I would do is build a query based on your data, sort it by name and then date. Use the query as a source for a listbox. Add code to the list box that opens the record the user clicks on.