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
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