Form by Table/Query

[Kevin Labore]

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

 

[John W. Vinson]

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.

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]