is it just the number yout need to increment?
say you had 15 rows in the table, you'd want the textbox to show 16?
why not use =Count+1
i suppose you could open a recordset and loop through gathering the names and adding them to a string. then just add the string to the textbox.
hmm..how do you intend to save it? inline SQL? a query? setting the name to a text box?
On the After_Update of the combo box put
Me.txtbox = Me.combobox.column(0)
that will assign the name of whatever it is to the text box. hopefully that will let you expand on your solution.
cant you use a recordset to find the number of records in a table using Count()
then increment this value. alternatively use a combo box that has a MAX statement as a row source then just reference this value and increment it?
debug is where you insert breakpoints in your code to "step" through it and find what is going on behind the scenes. That way you can see how the code is executed and if it doing what you want it to do
if the sub form is bound you wont be able to assign any values to the fields in it,,,i dont think. Cant you use the OpenArgs to pass in the ID?
DoCmd.OpenForm stDocName, , , , , , ValueOFIDtopassIn
ill assume that the report is bound to a table? and the checkboxes are based on yes/no fields?
(big assumption i know)
then a select statement would give you the number of checked boxes
e.g. SELECT * WHERE check = yes
and the total value would be something like
SELECT * WHERE check = yes OR No