Change Table of Split Form

[civl_eng]

Hi everyone
i have to table in access and i created SplitForm for Table1 in access, but now i want to change Table1 to Table2 in SplitForm and show Table2 in detail section of SplitForm, for this i change record source option to table2 in form properties but it show table1 in SplitForm again, how can I do this?



thanks,

[June7]

Changing the RecordSource property and saving the form with this edit is the correct method to accomplish. You will also have to change the ControlSource property of each control unless the field names are all the same. Which prompts the question - if the field names are the same in both tables, why do you have two tables?

[RuralGuy]

I suspect you marked this thread as Solved instead of answering June's question. Is it solved or are you just going away?