Give options when Click on a Submit Button

[JezLisle]

I have a form that the user will input a series of details, once they have completed all the fields I have a submit button which makes sure everything is written to my table. What I am trying to do is that once the Submit button is clicked is 2 things.
1 - Submit all data to the table as normal
2 - If in one of the Combo Boxes on the form show Complaint Enquiry. I then want the Submit button to enter some of the details from this form into another form, so that the user can add more details to this other form and create a complaint enquiry. This can then be written to another table in my database for all the complaints.

Is this possible to be done?

Jez

 

[Guus2005]

A little puzzled on what it is you are asking. I believe it is this: Is it possible to show data from one form on another? If that's the question: Yes, you can:

me.secondform.txtExtraInfo = me.firstform.txtName

Enjoy!

 

[geekay]

Sure it can be done. There are various methods to do this. If the second form is a subform of the first it is rather easy. Don't bother, it can be done if it is an independent form too.

Can't explain more without knowing the user interface and other details. Attach your mdb file to get the right answer.

Feel free to ask for my email address if you want a personalized support

 

[JezLisle]

Thanks, find attached the database.

Basically what I am wanting to do is...

When the user is inputting data on frmInputQuestions, there is a Combo Box called cboActionType. When the user chooses the answer "Complaint Enquiry" and completes the rest of the fields within frmInputQuestions. Once finished the user will then click on the Submit button called cmdSubmit

What I want to happen is that if in cboActionType "Complaint Enquiry" is selected then it completes the code as is in the cmdSubmit but also opens another form frmInputComplaint and inputs the details from the fields in frmInputQuestions and prompting the user to continue and input the rest of the fields within frmInputComplaint.

Hope this explains it better, dont hesitate to email me if you wish
jez.lisle@sky.com

Thanks,
Jez

 

[JezLisle]

Geekay, Has that explained what I am trying to do better?