calling a function from control source of text box

[jimlee]

Hi, can anyone help me with this?

I have a form for data entry and one of the text box fields has a control source of
"=ActiveClientCount([ID])"...this refers to a function which returns an integer value and uses the ID field of the form as it's parameter (this is an autonumber field).

My problem is twofold:

1) As this is a data entry form, the ID field is null when the form is first opened and thus the text box shows the error "#Number" which looks untidy.

2) The function is referred to in the control source property of the text box, so how do I then bind this to the underlying table?

I could probably 'get round' these two problems but i'd like to know if there are actual text book ways of doing it first as my boss will probably look at this when it's finished!!

any help much appreciated


jimlad

 

[Monk010100]

For your second problem, you could hide a bound textbox on your form (txt.Visible = False) and assign it the value in the original text box.

 

[randy700]

How about....

=iif(isnull(IDField),"",ActiveClientCount([ID]))


Randy

 

[jimlee]

Both problems now fixed, thanks very much for your help

jimlad