FYI. It generally considered good form to ask one question (with a
descriptive subject line) for each question.
See comments In-Line:
I am a beginner, still trying to find out that if I create a relationship
between 2 tables, and I fill one table up, will the second get filled up
too?
No. Simply creating a relationship will not add records to the Many-side
table when you add a record to the One-side table. However, if you use a
Form/Subform, the subform control will take care of adding the primary key
value of the record in the main table to the foreign key field of the
related record in the child form. On my website
(
www.rogersaccesslibrary.com), there is a small Access sample database
called "FormSubform.mdb" which illustrates this.
now with regards to the tab folder when creating forms, can I display a
query form on each tab folder?
I'm not sure I understand what you mean by "query form". However, if you
add a tab control to your form, you can add form controls to each tab so
that those controls will only be visible when that tab is clicked. Each of
the controls on each tab will still be bound to the underlying table (ie
that the form is bound to) or if it is a subform control, it will be bound
to the table the subform is bound to
how do I create a combo box that would actually save the values I enter
inside, and if the value I want isn't available be able to type it in... al
to be saved in a field in a table. Example country field.
The easiest way to do this is to set the "Limit To List" property to NO.
However, I do not recommend this. Generally, combo boxes are filled by
values stored in separate tables. When you try to add something that is not
in the list, you can use code in the "NotInList" event to add values to the
other table. On my website, there is another sample called: "NotInList.mdb"
which illustrates.
--
--Roger Carlson
Access Database Samples:
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L