If some TextBoxes are bounded with a table and you change the recordSource of the form, these TextBoxes will have no data and also an error because they are bounded to another RS which is not the actual one
Is not easy:
1)In the Form must not have any RecordSource.
2) In the Header of that form you must make a control do by certains
condition what RecordSource must use the form.
3) Enable the Detail of the form when you uptate the control of point 1).
If you want i send an sample of that, but not now because i must go.
I do it, two in one.
1)The form is "AltasCD Masivos"
2) When you open the form if you selecc in the control "Recorrido" one the RecordSource is by recorrido, if that control is null, the RecordSource is other.
That all, see the code.