1 Form multi table entry

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gorgsey - 29 Apr 2008 23:21 GMT

I'm trying to create a form for data entry, the form will be used for
entering data into 4 unrelated tables. I have bound the form to one of the
tables (text entry only), the rest of the data to be entered is check box. I
can't seem to get the check box entry to work. I insert an unbounded check
box and change the control source to "=[table 1]![field 1]" but when in form
view the check box is not active. Is what I'm trying to do possible, am I
making a simple (novice) mistake? I'm sure I have have done this in previous
versions of Access (2003) and seem to rememeber that I could add another
tables fields to a form with out creating relationships between the tables,
however when I try this in 2007 it wants to set up relationships between the
tables.

Many thanks for assitance

Reply to this Message

strive4peace - 30 Apr 2008 09:41 GMT

Hi Gorgsey,

You cannot do this:
--> 'change the control source to "=[table 1]![field 1]" '

it is best to use one form or subform to put data into each table. If
the tables are unrelated, and you want everything on the same screen, I
suggest you make a form for each table, then use those forms as subforms
on one main form pulling everything together into one place for editing.

Why do you have unrelated tables? What type of information do you have?

for better understanding of the basics of Access, read this:

Access Basics by Crystal (Access MVP site)
http://www.accessmvp.com/Strive4Peace/Index.htm
8-part free tutorial that covers essentials in Access

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*

> I'm trying to create a form for data entry, the form will be used for
> entering data into 4 unrelated tables. I have bound the form to one of the
[quoted text clipped - 9 lines]
>
> Many thanks for assitance

Reply to this Message