Filling Field from one Form to Another

[Xander117]

Okay so I have a form that the user selects fills in some information through txt boxes and combos, and then it opens excel applies the information to worksheet saves the worksheet and mails it to the tech as an attachment. Now I want the information that they fill in to also be added to another form in the database. It doesnt have to open the form I just want it to create the issue so it can be accessed by testers.

I ve been trying to do something like this but Im getting Invalid use of Property.

DoCmd.OpenForm "Test 2", acNormal, , , acFormAdd
 Forms!"Test 2.txtTrial1" = Me.txtTrial

Any ideas?

 

[guerillaunit]

Hi Xander, are you looking for the fields in another form to be automatically filled when you fill in the fields in this form?