RowSourceType (User Defined Function)

neil_turner

Registered User.
Local time
Today, 20:12
Joined
Mar 4, 2002
Messages
16
Hi,

Im trying to get a user defined function for the RowSourceType of a listbox to work. Unfortunatly Access (97) tells me my user-defined function 'may not be a valid setting for the RowSourceType property, or there was a compile error in the function'. Theres no need for me to post my code as I get exactly the same error when I build a form and module with the examples microsoft give. Im calling the function with nothing set in the RowSource and just the function name in the RowSourceType (no preceding (=)).

Has anybody got this working in Access 97, as I have ways around the problem but as my application is growing at an alarming speed I dont want to have macros to call code if at all necessary..

Many Thanks
Neil
 
Here is the syntax to refer to a function in events:
=FunctionName(Argument1;Argument2)

Does it help?

Alex
 
Problem solved, the module I was using had a sneaky error within it. The user defined function would not work even though the function with the error was not the RowSourceType function that I was wanting to use. After working this out I have managed to get it all working. Nothing is ever simple..
 

Users who are viewing this thread

Back
Top Bottom