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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|