Remove subform from main form

[RenaG]

I need to remove a subform from the main form so that I can replace it with a new one. How do I do that? I don't want to delete the old subform just yet in case I need it later.

TIA!

~RLG

 

[boblarson]

The subform itself should be a form that is saved in the forms list anyway unless you dragged and dropped a table or query in Access 2007 or 2010 which then just puts the table or query on the form.

The subform CONTROL is such that you can just simply select a different Source Object from its SOURCE OBJECT property in the DATA TAB, if you select the subform control (the control on the parent form which houses the subform). You will have to change the Master/Child links too, if they are different from the other one.

So you don't have to "put another" subform on the form to do all of that.

 

[RenaG]

Thank you! That was easy. At least putting on the subform . But I ran into a snag when I tried to update the links. I clicked on the Link Master Fields and it displayed this message:

Parts of the link with missing pair fields will be ignored.

I clicked OK and the Subform Field Linker window popped up. Under the Master Fields I pressed the drop-down arrow and selected ID ( I need to link the Patient.ID field to the Diag.PatientID field - Diag being the table that drives this form ). When I press the drop-down arrow under Child Fields it doesn't show the PatientID field. Now why would that be? It shows all the other fields in the Diag table.

~RLG

 

[boblarson]

The PatientID field needs to be included in the recordsource of the subform. If it isn't there, then it will not be available.

 

[RenaG]

Got-cha. I added that in and it works great now. Thanks so much!

~RLG