Tab

B

Bill

Im building a database which I think in theroy should be easy but of course
Im stuck! :-0

The database is nothing more than a daily activity log. The way I'm
designing it will be one form with a tab. The form or top half will have the
name datea and shift the person is working. The tab will contain line items
representing the activity (one activity per line).

So I have the top created (form log_main) and a tab with a sub-form
(sub_log)containing the data. Then I tried to connect them but realized
rather quickly that I have one main record with multiple sub records. So I
know there is a way to link this, but being the newby I am, I'm blanking out.
Ideas? Suggestions?

Thanks,
 
M

mcnews

Im building a database which I think in theroy should be easy but of course
Im stuck! :-0

The database is nothing more than a daily activity log. The way I'm
designing it will be one form with a tab. The form or top half will have the
name datea and shift the person is working. The tab will contain line items
representing the activity (one activity per line).

So I have the top created (form log_main) and a tab with a sub-form
(sub_log)containing the data. Then I tried to connect them but realized
rather quickly that I have one main record with multiple sub records. So I
know there is a way to link this, but being the newby I am, I'm blanking out.
Ideas? Suggestions?
Click to expand...
look at the data property of the subform. you'll need to match a
priamry key field from log_main to a foreign key field on sub_log.
 
L

Linq Adams via AccessMonster.com

First, you mention a "form with a tab." Unless you have more than one tab,
you don't really need the tabbed page; the subform can go directly on your
main form.I say this because there are people who think you have to have a
tabbned page to do this.

I assume you have a field that is common to your main form records and the
records on the subform. In Design View, select the subform control, goto

Properties - Data and set the Link Child Fields and Link Master Fields
properties to the appropriate field names.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Managing Sequence numbers between 3 sub forms on 3 tabs populated bythe same table 1
Tab Contol Question 2
Convert First Line indent into Tabs 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Controlling a Sub Form 4
set focus & screen movement 4
Dumb question about tabs or tabs with subforms 5
tab control page selector tabs not visible when form opens 1

Top