Change Table of Split Form

**civl_eng** · 07-09-2017, 03:33 AM

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** · 07-09-2017, 10:45 AM

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** · 07-10-2017, 08:32 AM

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

Change Table of Split Form

Thread Tools

Change Table of Split Form

Similar Threads

Change a basic Access entry form to a split form?

Split form - Hide columns only in DATASHEET part of split form

Split form table layout not saving in old db

How to change the column heading in a "split form"

making a table from a filtered split form

Posting Permissions