Need to display a single main form with 48 subforms

[c0l0nelFlagg]

I need to display a main form with 48 identical subforms. 6 columns with
8 rows.

I set up a separate query for each subform, identical in structure and
underlying data except the criteria in two fields is different for each.
(ie Row and Column id fields).

I am able to select data in each subform from combo box lists, then on
after update event I want to store data in a master underlying
transaction table, both when each subform is updated individually as
well as when a single cmd button in the parent form is clicked to update
all data from all subforms.

Any ideas or suggestions on code to use, as MS Access 2002, I have here,
will only allow 42 simutaneous queries; so it limits effectiveness.

Thanks

TheC0l0nel

I wasn't here ! ***grin***

[Salad]

c0l0nelFlagg wrote:

I need to display a main form with 48 identical subforms. 6 columns with
8 rows.

Why?

The concept of making a mountain our of a molehill comes to mind.

I set up a separate query for each subform, identical in structure and
underlying data except the criteria in two fields is different for each.
(ie Row and Column id fields).

I'll bet you've been as busy as a beaver.

I am able to select data in each subform from combo box lists, then on
after update event I want to store data in a master underlying
transaction table, both when each subform is updated individually as
well as when a single cmd button in the parent form is clicked to update
all data from all subforms.

Any ideas or suggestions on code to use, as MS Access 2002, I have here,
will only allow 42 simutaneous queries; so it limits effectiveness.

Microsoft didn't anticipate you.

Did you know you can do something like
Me.Recordsource = QueryName
or
Me.Recordsource = "Select * From TableName Where Status = 'D'"
?

It almost sounds like you are using the same table, the only thing being
different is some criteria. You could use the command
Me.Filter = "Status = 'D'"
Me.FilterOn = True
and filter. So you could have a listbox, select a value in the listbox,
and filter as necessary?

At best I might have 2 forms; main transation and then one to display
the data to update the main transaction table. Then use filters to
display the data.

Thanks

You're welcome.

Long Hot Summer
http://www.youtube.com/watch?v=h9nU63N5d1w

TheC0l0nel

I wasn't here ! ***grin***