Subform Help

[Guest]

Hello,

I am trying to create a subform linked to a master form.

The master form will be based off of the Month and show the accounts that a
person owns.

I have three tables

Acct Rec Tracker: It contains a referenced ID called
Internal_AcctRecTracker and Person_ID. This holds the data for Account
Numbers and Person. The account numbers info is then displayed in a subdata
sheet MAINTENANCE.

Maintenance: This is a subdata sheet from Acct Rec Tracker. This holds all
the months, balances, and information. ID's are Internal_AcctRecTracker and
Month_ID.

Month: It is a table that just contains the 12 months and Month_ID.

What I am trying to do is display the account numbers in a datasheet form
which then links to the corresponding month and person.

So say if person A has 50 Accounts. If I did a parameter query on the month
box. I will see Person A's 50 accounts.

Right now I just tried to create a query, and grab the data from there.


First How do I set up the links and then how do I do the parameter query,
[forms]![XXXX]![listbox].

 

[[MVP] S.Clark]

Set the Link Child Field and Link Master Field property of the Subform
control.

 

[Guest]

See the thing is I did that already. Since the Account Rec Tracker Contains
all the other info and the Maintenace contains the Monthly Data (subdatasheet
from Acct Rec Tracker), I doesn't seem want to link from Maintenace to
Account Rec Tracker.

For example:
Acct Rec Tracker
Account Number Internal Account Rec Number Preparer
11111-xxx-111 1 Bob
1111-xxx-2222 2 Jim
1111-xxx-3333 3 Sam

Maintenance
Monthly Data Internal Account Rec Number Amount
Jan 1
10
Feb 1
10
March 1
20
Jan 2
30
Feb 2
20
March 2
20

So I want the data to be displayed in the form as

Month Preparer
Subform= Account Numbers for the month

So if the user is looking at the data he can view each account by the months
account by preparer.

But for some odd reason since the Acct Rec Tracker is the main form and the
maintenance is the subdatasheet. I will not allow me to do that.

Could it be becasue of the relationships.

Acct Rec Tracker 1 to infinity Maintenance.

Thanks

Set the Link Child Field and Link Master Field property of the Subform
control.

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

Hello,

I am trying to create a subform linked to a master form.

The master form will be based off of the Month and show the accounts that
a
person owns.

I have three tables

Acct Rec Tracker: It contains a referenced ID called
Internal_AcctRecTracker and Person_ID. This holds the data for Account
Numbers and Person. The account numbers info is then displayed in a
subdata
sheet MAINTENANCE.

Maintenance: This is a subdata sheet from Acct Rec Tracker. This holds
all
the months, balances, and information. ID's are Internal_AcctRecTracker
and
Month_ID.

Month: It is a table that just contains the 12 months and Month_ID.

What I am trying to do is display the account numbers in a datasheet form
which then links to the corresponding month and person.

So say if person A has 50 Accounts. If I did a parameter query on the
month
box. I will see Person A's 50 accounts.

Right now I just tried to create a query, and grab the data from there.


First How do I set up the links and then how do I do the parameter query,
[forms]![XXXX]![listbox].

 

[Guest]

Steve,

I did what you told me now. But I run into an error. I have the month and
the reviewer showing all the account in the subform.

So say if I do a filter on the form by month and preparer, for example it
will get me the month of November and for Lee and all the accounts I own.
But it will repeat my name to the number of accounts, 15. I am not sure why
it does that. I want it to display the months and preparer and all the
accounts on one record, not 15 times because of the accounts.

Here is the link from the subform to form.

Link Child Fields: Date;Preparer
Link Master Fields: Date;Preparer

I can do what I want in a query, but I want to present it in a form.

I can send you the database if you need to see it. Thanks.

Set the Link Child Field and Link Master Field property of the Subform
control.

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

Hello,

I am trying to create a subform linked to a master form.

The master form will be based off of the Month and show the accounts that
a
person owns.

I have three tables

Acct Rec Tracker: It contains a referenced ID called
Internal_AcctRecTracker and Person_ID. This holds the data for Account
Numbers and Person. The account numbers info is then displayed in a
subdata
sheet MAINTENANCE.

Maintenance: This is a subdata sheet from Acct Rec Tracker. This holds
all
the months, balances, and information. ID's are Internal_AcctRecTracker
and
Month_ID.

Month: It is a table that just contains the 12 months and Month_ID.

What I am trying to do is display the account numbers in a datasheet form
which then links to the corresponding month and person.

So say if person A has 50 Accounts. If I did a parameter query on the
month
box. I will see Person A's 50 accounts.

Right now I just tried to create a query, and grab the data from there.


First How do I set up the links and then how do I do the parameter query,
[forms]![XXXX]![listbox].