user defined function incorrectly running on form open 1

[sub5]

Hi all,
I get error 3021 no current record when I open a form which has listbox whose row source property is refering to to a user defined function which moves through the records in a query to populate the list box.

There is nothing in the listbox row source.

The function is a private function in the form's module.

I know there is no current record because I need to create some before I get to the list box. I am not querying the list box in any procedures relating to opening the form.

Why does it jump to my user defined function on form open?
What do I do to stop it running that procedure until I want it too ie until I have created the data? (I have tried disabling the listbox until I want it but that failed)

 

[Troyston]

Why not, that's where it gets the rows from.
put something like:


if nz(.recordcount,0) > 0 then
do some stuff
call the function etc
populate the list box
else
do something else or nothing
endif

Troyston

Troy Vinson
Trading as IT Supportman

http://www.itsupportman.co.uk

 

[sub5]

That did it, cheers Troy.

 

[Troyston]

No Problem, I always try to answer a few questions when I'm fishing for an answer myself.



Troy Vinson
Trading as IT Supportman

http://www.itsupportman.co.uk