Recent content by giuseppeking

yes but look at the sum in the subform It doesn't sum anything so it is obvious that you can't see the value in the main form.. SUM is defined for sql statements so.. :)

but.. you need a tableXX with the association Town --> municipality

yep.. simple.. you use this query as source of the combobox: SELECT town, municipality from TableXX you don't show the municipality in the combobox and on AfterUpdate event you write this code: textfieldMunicipalty.Value=combobox.column(1) ' 1 because the count starts from 0 That's it..

ehm you use the SQL function SUM on a field value.. That is the problem.. I can give you an advice.. it's the first solution I have in my mind.. there are probably better and faster ones.. but .. :) build a matrix with the BARCODE and SUBTOTAL in two columns BARCODE SUBTOTAL ---------...

or.. you can run a query with COUNT and similary get the count of the records.. as you prefer!!

not so difficult.. I can help you using DAO.. you can use this code: Dim db As DAO.Database Dim oTD As DAO.TableDef Dim counter as Integer Set db = CurrentDb Set oTD = db.TableDefs(yourTableName) counter = oTD.RecordCount if combobox.value="" then MsgBox "ERROR: empty combobox!!"...

hi, I'm trying to send a chart that I display in a form to a report. How can I do this? It is a MS chart object.. thank you, Giuseppe