I have a form, frmProjectDetail, which is bound to tblProjectDetail. On this form are two fields, "txtJobN", and "txtDetailID". Neither one of these fields are indexed because there can be duplicate records for "txtJobN". However ther can only be one "txtDetailID" record number 1, number 2, number 3, etc.
On form frmProjectDetail is a command button. When the button is clicked I want a 2nd form, "frmFinancialInfo", bound to tblFinancialInfo, to open, leaving form 1 open. In the second form then are two fields that I want populated with the values from frmProjectDetail... the same two fields as in the 1st form. And I want this record to be written to tblFinancialInfo after a couple other fields are filled in.
How can I do this?