Use form or build sub-form

[eddacker]

hello, all.
I have a main form called ResidInfo and I want to add some forms for data entry off the new (paper) survey forms the (700) residents have completed for us.
I think using tab controls for each section of the submitted forms will work.

My Question:
What is the difference (if any) between placing the tabs and dropping stand alone forms on them -vs- building sub-forms on the tabbed pages?

TIA eddacker

Additional info:
The survey form suggests 4 additional entry forms:
Contact Information (3 or 5 phone numbers).
An editable list of Visitors and regular service people.
An Owner's information page for the 8% that are tenants.
And a 'notes' page to enter real time data when they email or call the office.

 

[eddacker]

I don't know what you mean?

I built some forms before I decided to go the tabbed route. But dragging and dropping them seemed to cause problems. So I couldn't decide to fix what I had or build sub-forms.

 

[eddacker]

thanks for your encouragement. I went back over my process and found the errors in the master/child setup.
and learned a bit more about design.
cheers,
eddacker

 

[isladogs]

I built some forms before I decided to go the tabbed route. But dragging and dropping them seemed to cause problems. So I couldn't decide to fix what I had or build sub-forms.

What were the problems you had with tabbed forms?
E.g. Did the controls 'bleed through' from one tab to another?

 

[eddacker]

It seems when I drag and dropped and used the wiz I was able to set the master/child and when I did it manually (w/o the wiz) I could not find the settings.

I just don't have time to list all the cases where you have to do something strange to make Access happy. – Johnny Bones