Visual Basic&database, Access97 beginner - RowSourceType property problem/question?

Access97 beginner - RowSourceType property problem/question?

Author	Message
Scott Fulle #1 / 2	Access97 beginner - RowSourceType property problem/question? Hello, I've created a VB function that builds and returns an SQL SELECT statement from the value of a Text Box which works exactly as it should when called on it's own. I've set the RowSourceType property of a List Box to a function named SqlQryStr but every time I run the Form containing this List Box Access97 reports with an information dialog box that reads; 'SqlQryStr' may not be a valid setting for the RowSourceType property, or there was a compile error in the function I have the RowSourceType property of the ListBox set to SqlQryStr without a preceeding equal = sign and without any trailing parenthesis () as the Access97 help file indicates it must be. I've tried setting the return type to a string and a variant type and it makes no difference either way. Could anyone please tell me what I'm missing here? I'd appreciate any replies cc'd to me via email at: the newsgroup as well. Thanks in advance, Scott Fuller Derry, NH -- Please remove Ihs from email address to reply by email
Sun, 29 Jul 2001 03:00:00 GMT

Ted Gordo #2 / 2	Access97 beginner - RowSourceType property problem/question? Are you setting this property on the property page? If so, try setting it in the form load event Ted Gordon Quote: >Hello, >I've created a VB function that builds and returns an SQL SELECT >statement from the value of a Text Box which works exactly as it >should when called on it's own. >I've set the RowSourceType property of a List Box to a function >named SqlQryStr but every time I run the Form containing this List >Box Access97 reports with an information dialog box that reads; >'SqlQryStr' may not be a valid setting for the RowSourceType property, >or there was a compile error in the function >I have the RowSourceType property of the ListBox set to SqlQryStr >without a preceeding equal = sign and without any trailing parenthesis >() as the Access97 help file indicates it must be. I've tried setting >the return type to a string and a variant type and it makes no >difference either way. >Could anyone please tell me what I'm missing here? >I'd appreciate any replies cc'd to me via email at: >the newsgroup as well. >Thanks in advance, >Scott Fuller >Derry, NH >-- >Please remove Ihs from email address to reply by email
Tue, 31 Jul 2001 03:00:00 GMT

Page 1 of 1

[ 2 post ]