form captions

[Coleman984]

I was wondering if it is possible to assign this to a form caption forms!frmEmployee.comNumber. Like this

"Employees with more than " & forms!frmEmployee.comNumber & " point(s)"

Or something like that.

Failing that is there a way to set a query caption?

 

[Mr. B]

Try using the following code in the On Current event of your form:

Dim strCaption as String
 
strCaption = ""Employees with more than " & Me.comNumber & " point(s)" 
me.caption = strCaption

 

[Coleman984]

that works. Thanks.