Verification of Last Record Entered

[Sondra]

I have a form that requires the user to enter all data prior to being able to
close the form A Command button at the end of the form "Return to Main Menu"
verifies all fields have been completed and will not let the user exit if the
fields are not completed. If the fields are completed the command button
returns to main menu.

I want to try and add another twist to this.

I would like to have the user verify that the number they have written down
is the number they just recorded. I have another form that the users can
look up their number on at a later date, but I want to force them to open
that form immediately upon exiting the entry form.

Here is what I was thinking:

Msgbox "Verify your Case Number is Correct", vbCritical, "VERIFICATION NEEDED"
DoCmd.OpenReport "rpt_DSCR", acviewpreview

I discovered as long as the form is open then the number doesn't appear;
however, if I close the form and run the option to look up the number the
number is there.

Basically I need is to have the user re-enter their number and verify the
data is true.

Any advise.

S