ok frmForm has record feilds including an ID feild. frmComment has 3 feilds ID, Comment, and Date.
The Date feild on frmComment is autodate = no problem
The Comment Feild works = no problem
The ID Feild needs to change to what ever the record ID as it reads in frmForm.
The frmForm has a command button that opens the frmComment.
I need the ID TextBox on frm comment to populate and write to the tblComment with the number shown in the ID TextBox on the frmForm.
I hope this is not confusing
Thanks
Krash
The Date feild on frmComment is autodate = no problem
The Comment Feild works = no problem
The ID Feild needs to change to what ever the record ID as it reads in frmForm.
The frmForm has a command button that opens the frmComment.
I need the ID TextBox on frm comment to populate and write to the tblComment with the number shown in the ID TextBox on the frmForm.
I hope this is not confusing
Thanks
Krash