Access form -updating details for Not in list

5 pts.
Tags:
Microsoft Access
MS Access 2007
I have created a form "Transactions" for data entry. One field, "Account", selects from an existing list, but can accept new Accounts. When I accept a new account, I would like to be prompted to go to the "Account" form and fill in the Account description on 4 additional fields (Title, Category, Requester, Date). Once this done, I would like to return to my initial "Transactions" form to fill in additional information.

I use Access but I am not a programmer. Can you help me with detailed codes on how to do this?



Software/Hardware used:
MS Access 2007

Answer Wiki

Thanks. We'll let you know when a new response is added.

In design mode chosse the field you have in question. In the propert sheet chose “Not in List” and chosse “Event procedure”. Then click on the “…”. Enter the following code.
“Dim iAnswer As Integer
iAnswer = MsgBox(“WHAT IS NOT IN THE FILE. Add (Yes/No)”, vbYesNo + vbQuestion)
If iAnswer = vbYes Then
DoCmd.OpenForm “KEY THE FORM HERE”, acNormal, , , acAdd, acDialog
Response = acDataErrAdded
Else
Response = acDataErrContinue
End If”

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Now we know what you would want to do, could you please let us know what part exactly you need help with ?
    69,175 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following