Form code not working

G

Greta

I have the following, which does work:
Private Sub Specific-control_AfterUpdate()
If Specific-control = "FAILED" Then
DoCmd.OpenForm "2nd-form Form", acNormal
DoCmd.GoToRecord , , acNewRec
End If
End Sub

I also need the "Specific-control" control to show the
value of a text box in the 2nd-form if it = "FAILED".
So, if data entry enters "FAILED", they jump to the 2nd-
from, fill it out, and return to the first-form and
Specific-control should read what the text box reads.
Make sense?
Help,
Thanks,
Greta
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top