Hi,
I would like to use the setvalue command within a macro to change the record source of a form from one table to another.
I have entered [Forms]![T/C Mux].[RecordSource] into the item part. I have not been able to come up with what to put in the expression part.
The two tables are called T/C Mux_1 (Current) and T/C Mux_2 (Required). As the source data for the form is going to be switched fairley regularly I was going to change the record source using a couple of buttons.
Can any one put me on the right track?
Thanks
I would like to use the setvalue command within a macro to change the record source of a form from one table to another.
I have entered [Forms]![T/C Mux].[RecordSource] into the item part. I have not been able to come up with what to put in the expression part.
The two tables are called T/C Mux_1 (Current) and T/C Mux_2 (Required). As the source data for the form is going to be switched fairley regularly I was going to change the record source using a couple of buttons.
Can any one put me on the right track?
Thanks
