Form by Table/Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin Labore - 29 Jul 2007 15:12 GMT

I have a question to pass a list from either a table or query.

I have a list of departments for example and I want to pass these (sorted by
Category(Div#) and Dept#) so I dont have to enter them in the subform.

Presently I have the following tables:
DeptDate (the week end date(Sat) that the Sales Occured)
DeptSalesDetail (The Detail of DeptSales that occured on the DeptDateID)
Depts( The Dept#, Desc, Div(Cat))
Div (called division basically a category, Div# and DivName)

Goal to have the Subform automatically enter the Div# and Dept #(and Display
Deptname as well) so I dont have to manually enter 50+ lines for each
week(just enter the Sales$) -- Presently I have to type the department #'s.

I know how to do a selection list for each record.(ie. Red/Blue/Green) but
not how to do a set of records.

Thanks
Kevin

Reply to this Message

John W. Vinson - 31 Jul 2007 18:12 GMT

>I have a question to pass a list from either a table or query.
>
[quoted text clipped - 10 lines]
>Deptname as well) so I dont have to manually enter 50+ lines for each
>week(just enter the Sales$) -- Presently I have to type the department #'s.

One way to do this is to have controls for the Dept and Div (I'd recommend NOT
using the # character in fieldnames, it's a date delimiter) on the mainform;
include them in the Master and Child Link Field properties.

What are the recordsources of the main and subform? You're not storing the
Dept# redundantly in both the main form's table and also the subform table,
are you?

John W. Vinson [MVP]

Reply to this Message