Please advise - currently using Access 2002

S

Sondra

Here is what I have:

1. I start with a switchboard that opens a form in add mode
2. The user's enter all the required data and when they have finished they
press a button to return them to the switchboard. The coding for the command
button is:

Private Sub MenuBut_Click()
If IsNull(Me.Department) Or IsNull(Me.State) Or IsNull(Me.Initials) Or
IsNull(Me.Date) Or IsNull(Me.WBN) Or IsNull(Identifier) Or
IsNull(DonorLastName) Or IsNull(DonorDOB) Then
MsgBox "You left a required field blank. Please go back and enter the
required information", vbCritical, "Field Required"
Else
DoCmd.RunCommand acCmdSaveRecord
MsgBox "Verify your Case Number is Correct", vbCritical, "VERIFICATION NEEDED"
DoCmd.OpenReport "rpt_DSCR", acViewPreview
End If
End Sub

When the user clicks this button the report opens and verifies that the
Number they just entered was there. If the report comes up blank it verifies
that the number didn't get accepted into the system.

Now this is where my problems begins. The user clicks the close button on
the report window and it returns the user to the Switchboard. (The report
close event procedure is set to open the frm_DSCRSB).

But if the user presses the button to initiate a new DSCR (opens the
INITIATE DSCR FORM) the correct form is open; however, it opens to the same
record that was just being verified.

I'm not sure how to fix this or where I need to write more directions. I
want the INITIATE DSCR FORM to close and save when the user closes the report.

Does this make any sense.

Sondra
 
Top