Search results

:o Hello Meltdown! Look at "DemoTabA97.mdb"

:o Hello Brewmeister! I saw your ".mdb", I add a COMBO BOX in testform. Try it, I think it is what you wont. I hope that the serial number is unique.

:p Hello highland! Look at "DemoRPTA97.mdb"

:p Hello Brewmeister! Look at "DemoQryFormA97.mdb" I think it is wat you need.

;) Hello longIT! I think you need something like this.

:p Hello Mkkashif! Before the first "End If" write Exit Sub

:o I forgot, you can write in criteria Like "*" & [Forms]![Form1]![Text0] & "*"

:o Hello Darrel Wootton! Look at "DemoLike2A97.mdb"

;) Hello Mkkashif! Look at "DemoEscA97.mdb"

:o Hello gersy! I suggest you to try with a query. Or remake your "mdb" in "tblDate", "tblClient", "tblContract", and "frmDateMain", "frmClientSubform", "frmContractSubform".

:o Hello ym2004! Look at "DemoSubDateA97.mdb"

:p Hello heaps21! Look at "DemoVehicleA97.mdb"

:) Hello Chimp8471 If you have a "Solutions.mdb" look at it. there you'll find "Create advanced reports", (select it) and "Create a crostab report with dynamic column headings". If you have not "Solutions.mdb", look at my "DemoCrostabA97.mdb". It is a short example. First open form "OpenMe".

:p Hello mjd! Look at DemoAssetA97.mdb

:) Or the beter way = (Sum([Project Appropietron] + [Changes])-([SShareBudget] + [Changes]))

:cool: Hello wilhels try this: in subform field properties = (Sum([fieldName]))