Eureka! Your "silly" question tied directly to my silly mistake of leaving "myform" in the control source of the text box. Once I specified the form correctly, and the function works and I have row numbers. I guess I still have a ways to go before I can call myself an Access developer... Thanks so much for your help!
Jeff
Jeff Williams
Last Activity: Jul 27 '07, 01:57 PM
Joined: Jul 17 '07
Location: Huntsville, AL
-
Unfortunately, I had tried changing the name of the textbox before, and still got the "#Error" displayed when I ran the form. Another thing I did was to put a debug breakpoint in the public "rownum" function, and it never triggered. I had copied the function declaration right out of the posting and into a module, so I'm not sure what I could've done wrong there. As a test, I created a new form from scratch, added a textbox...Leave a comment:
-
Problem Calling Public Procedure
I'm an old PowerBuilder developer that is new to Access development, and I'm stumbling on getting the rownum function to work. I've added the "rownum" public function to an existing module within my application, and I've added a textbox called "rownum" to my form with the controlsource you suggested. When I run my form, I get "#Error" displayed in the rownum textbox in each row of the form. Any idea what I might be...
No activity results to display
Leave a comment: