Force Continuous Subform to Display all 10 Rows?

[clearwave]

I have a Continuous Subform on my Main Tabbed form.(See image below)
[image

http://cerberus.clearwave.com/jerry/frmRoc.gif

]
[image

http://cerberus.clearwave.com/jerry/frmRoc2.gif

]

When the user clicks this Tab, I need the subform to open and automatically display a row for each of the values in dropdown box Combo12. (Combo12 is based on a Table that curently has 10 items in it but will grow in the future)
I do not care if this is a drop-down or text box field as the user will not be allowed to change.

To make it easier for an end user to input the Totals, how do I have this subform open, with a row for every item in my table that isn't discontinued? (This table has the following fields, ID, Desc, & Discontinued checkbox)
[image

http://cerberus.clearwave.com/jerry/frmRoc3.gif

]

Thanks for your help, Hope this is enough information.

 

[Pampers]

Hi Clearwave,
Try again at

http://www.geocities.com/peteralaerds/ROC_beta_3.zip

Pampers
Just let it go...

 

[clearwave]

Pampers, Thanks for a workable solution.
I originally thought of doing it that way, but I kept hearing the voice that says, "break up the data into separate tables". So I broke it down & made the tblReceiptCatgs.

One question: How would you deal with categories that are discontinued? Add a DISC yes/no field for each?

Thanks again for your time.
I will re-organize my crosstab queries & reports to work with this design & see how it goes.

cw

 

[Pampers]

Like in your table SalesType with the field 'sls_catg_disc'. Furthermore, in your combobox, set the criteria on the field sls_catg_disc to 'no', and don't show the field in the combo (uncheck). The categories that are disconitued will not show in the combo. Of course soemwhere you have to have a button that popups a form where you can select the items that are discontinued...
Hope this helps


Pampers
Just let it go...

 

[clearwave]

Pampers, I have posted my updated database using your suggestions on both the Receipts & Sales tables & forms.
I took all of my Categories from Receipts & Sales & added them to the corresponding tblReceipts & tblSales.

I then fixed my frmROC Tab4 to reflect all of the Categories as you had recommended. This works great!

I no longer will be using the Combo Box at all. This does exactly what I was needing, as it lists all the possible items down the form & waits for the user to enter in the Dollar amounts.

My Monthly Reports & Crosstab queries are now all out of whack though, so I'll need to work those again.

I guess I still have not learned how to use the SQL APPEND INTO code...maybe next time...

Any other ideas?

Thanks again All,
cw