Bringing entered data from one textbox on a form to a textbx on another form

[sevanty7]

Hello,


I currently have two froms, "add record" and "add record cont."
The reason I have two seperate forms is because when clients create a new record information needs to be saved to two different tables and when creating one from with fields from both tables I ran into many problems.
The two tables are named : tblMain, tblFileLoc
Currently there is a textbox on both forms named "fileID" the FileID in the first form is from tblMain and is the primary key for that table, the FileID on the second form "Add Record Cont." is just a normal field.
When clients enter in the new FileID in the first form "Add Record" and then move onto the next form "Add Record Cont." i need access to bring the entered FileID from the first form and Fill it in the FileID field in the second form.
Currently I have tried making the control source for the textbox on the second form = the textbox on the first form but it brought up an error.

Thank you for any help

[amrut]

Currently I have tried making the control source for the textbox on the second form = the textbox on the first form but it brought up an error.

This will not work for a bound field.Instead, try it as default value.

[rzw0wr]

Are both forms opened at the start of the process.
When the add record form is opened does the add record cont form also open?

It also sounds like your tables need to be normalized some if you are try to save the same data in 2 different tables.

Dale

[sevanty7]

The way it currently is set up is that once the client has entered all the appropriate informationon the first "add Record`there is a save button that then opens the "add record cont." form. However it it would work more smoothly to open both at once that can be done

[rzw0wr]

On the save button On Click event you can try,

DoCmd.OpenForm "add record cont", acNormal, , "FileID=" & FileID, acFormEdit, acWindowNormal

Change FileID to whatever your record Id is for the recordset.

Run the after your save command.


Dale