Using Subforms in Microsoft Access

[@satyabanukil779]

Sir I have a simple query. I have only one table. There are numerous fields. Since a single table database, building relationship does not arise. But considering number of fields in the table. I want to split the fields in one form and one subform. Now I want to link two forms. In the main form if I change or enter new data, the subform shall display data corresponding to the field appears in both the forms. Shall be grateful if any advice is given. Regards

[@ComeauSoftwareSolutions]

Subforms are meant to support one-to-many relationships between tables. There would be no purpose to using a subform this way. I would recommend looking at the tab control in the form designer. You can put a series of tabbed pages on a form and split the fields up that way.