I created a form and subform, each pointing to a different table, table A and B, respectively.
For technical reasons, I needed to recreate table B.
I created a 2nd table (table B2) from scratch with the same fields and field types as table B.
I now need to change the table the subform links to, from table B to table B2.
I can’t seem to break the link from table B, regardless to what I do.
Do I need to completely recreate the subform and all its fields to link to table B2.
Thanks.
Open the form for editing, not for input data.
Click on one field of the subform → right mouse click → Form Properties
Go to tab “Data” and change content for the data.
If the table contains the fields with the same names and properties as before with old table this will be all.
Robert,
Yes, that makes a lot of sense. I have tried this several times, though, and I have not been able to get it to work. Have you had success with this? I’m running version 24.8.3.2. Thanks.
Yes, several times. I was using 7.x versions, but I don’t think there are much changes for Base.
I got it to work as RobertG described. Thanks.
The trick (and my mistake) was that the field names were the same for both the old and new table, but the case was different. Once I reset each subform field’s Data field to the new table’s field, it started working.
1 Like