Is This Possible

[Aussie60]

Hi

I have a form called frmProjectDetails, on this form i have textboxes which are populated with data from the tblProjectDetails after ProjectNumber is selected from a combo box. Also on the frmProjectDetails is a command button that opens another form called frmCVO. On the frmCVO are textboxes for entering data into the tblCVO also several other textboxes that need to be populated with data from thr frmProjectDetails. What I want to happen is that what ever the ProjectNumber is on the frmProjectDetails any data entered into the frmCVO will be saved to the tblCVO as the ProjectNumber

I know your probaly going to say why don't i just put a subform on the main form but I don't want to do that

Hope the above makes sense

 

[MStef]

Link "frmProjectDetails" (Main form) and "frmCVO" (subform) via
"ProjectNumber". Populate the "Link child fields" and "Link master fields"
properties. When you do that, you don't take a care for "ProjectNumber"
in the "tblCVO".

 

[Aussie60]

My frmCVO is a stand alone form not a subform so how do I link frmProjectDetails and frmCVO. Where do I do this. I know how to link a subform to the main form but the frmCVO is a stand alone form. ThefrmCVO is opened by a command button on the frmProjectDetails

 

[MStef]

Ok. here it is. Look at "DemoFormFormA2000.mdb" (attachment, zip).
Open "FormA" and click on the button. These two forms are linked via
"f1ID", "f2" (formA) and "f1R", "f2R" (formB).
Look at VBA.