Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Force Continuous Subform to Display all 10 Rows?

Status
Not open for further replies.

clearwave

Programmer
Sep 26, 2005
19
US
I have a Continuous Subform on my Main Tabbed form.(See image below)
[image ]
[image ]

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 ]

Thanks for your help, Hope this is enough information.
 
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
 
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 [afro]
Just let it go...
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top