Data entry - fields from 4 tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to be able to perform data entry for fields from 4 tables, in a
single data entry interface. (I'm using Access 2002, SP3.)

Is there a way for this data entry to be done from a single interface in
Form view?

The only data entry "interface" solution of which I am aware is not very
good. This solution consists of creating a Form from one table, and then
adding 3 separate subforms (each subform bound to one of the 3 remaining
tables). With this solution, data entry for the fields in the 3 subforms
must be done via the 3 subform "datasheets."

I find this data entry "interface" solution to be really poor. Further, the
solution is made worse because horizontal scrolling is required for data
entry into each subform (as the number of fields in each subform does not fit
in the visible portion of datasheet).

Any help will be greatly appreciated.
 
Subforms do not have to be datasheets. They can be continuous forms, or
single view forms as well. As an interface you can use a Tab control to
separate the pages or simply add a page break and use the PageDown/PageUp
keys to move between form areas. You can also show and hide subforms, or set
their height to 0 and make them visible in code by resetting their
properties.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
In a moment of distraction, I mistakenly clicked the "Yes" button, regarding
your reply to my question. Clearly, your reply was an answer (and
appreciated), but without some "how-to" info, I have no idea how to translate
your info into a "single" data entry interface for fields from 4 tables.

Please, would you provide some "steps" or "how-to" details?

Right now, I have one Form, with 3 subforms added to the Form. The Form is
bound to one table. Each subform is bound to one table. The 4 tables are:
Main, Detail, Author, and Subject. When I switch from Design View to Form
View, the subforms are presented as datasheets.

Thank you for your first reply!
 
Go to the Properties sheet for each of the three subforms. go to the
"Format" tab, and on the "Default View" property dropdown select "Single
Form" --- save those three change (one on each subform) ...
 
Thank you very much. This solution, just fixed my tiresome problem of 1
week. Thank. you again.
 
Back
Top