A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

1 Form multi table entry



 
 
Thread Tools Display Modes
  #1  
Old April 29th, 2008, 11:21 PM posted to microsoft.public.access.forms
Gorgsey
external usenet poster
 
Posts: 2
Default 1 Form multi table entry

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
  #2  
Old April 30th, 2008, 10:33 AM posted to microsoft.public.access.forms
strive4peace
external usenet poster
 
Posts: 1,670
Default 1 Form multi table entry

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
*



Gorgsey wrote:
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.