Show dcount result in command button caption

[bd528]

Hi all,

I'm trying to show text and a dcount result in a command box's caption. I've tried the following without success :-

Number of quotes by status & =DCount("[Quote_Status]","qryAcceptedQuotes")

Number of quotes by status & DCount("[Quote_Status]","qryAcceptedQuotes")

Is what I want to achieve possible?

Many thanks

 

[Ranman256]

button.caption = "Number of quotes by status " & DCount("*","qryAcceptedQuotes")

 

[bd528]

button.caption = "Number of quotes by status " & DCount("*","qryAcceptedQuotes")

Thanks - can this be done in desgin view? I tried using

"Number of quotes by status " & DCount("*","qryAcceptedQuotes")

but that literally showed in the caption

 

[Ranman256]

no, you need it in the form as code,
form event: ON CURRENT

 

[bd528]

no, you need it in the form as code,
form event: ON CURRENT

Thanks again.