I made a form based on a recordsource named "ProjectList"
On this form is a button "CountOff".
I wrote next code:
me.countoff.caption = Dcount("[worknr]","[qrysubform1]",
"[leadnr] = " Me!leadnr)
In this case: the button has the same number in the caption
for each record
but I want to loop through the recordset, so each button had an other number on it.
Which code can loop through the recordset;
For each .... in ......
me.countoff.caption = Dcount ("[worknr]","[qrysubform1]", "[leadnr] = " Me!leadnr)
Next ....
something like this?
If it's possible can somebody help me?
Thanx in advance,
Gerard
On this form is a button "CountOff".
I wrote next code:
me.countoff.caption = Dcount("[worknr]","[qrysubform1]",
"[leadnr] = " Me!leadnr)
In this case: the button has the same number in the caption
for each record
but I want to loop through the recordset, so each button had an other number on it.
Which code can loop through the recordset;
For each .... in ......
me.countoff.caption = Dcount ("[worknr]","[qrysubform1]", "[leadnr] = " Me!leadnr)
Next ....
something like this?
If it's possible can somebody help me?
Thanx in advance,
Gerard