Numbering records on a form

[Rob Amor]

I have a query which returns a list of 5 records at random and have been looking for a way to number these records 1 to 5 simply as a visual aid to users. I used the following code in an unbound text box on my form: =RowNum([Forms]![MyFormName]) and everything worked. Then I used this form as a subform and now get a #Type! error. I thought it would work since the code is contained in the sub form rather than being referred to from the main form but I am clearly missing something. Any advice would be gratefully received.

Thanks

[Rabbit]

If it's a subform, the form itself is no longer in the forms collection. You will need to access it through the parent form to the subform to the control.

[Rob Amor]

Thanks for the reply, I am not sure how to do that. I have tried putting the following code as the control source for the unbound textbox on the subform.
=RowNum([Forms]![MainFormName]![SubformName]) but am getting the same #type error
If I add the textbox name =RowNum([Forms]![MainFormName]![SubformName].[textbox] I get a #name? error.
I appreciate that I am missing something obvious and/or doing something daft but if you could set me right I would be most grateful.
Thanks

[Rabbit]

Do you need to fully qualify the control reference? Can you just not use the textbox name without all the form references?

[Rob Amor]

Without using [Forms]![FormName] the RowNum function doesn't work even on a straight form. I have tried various combinations to get it to work but usually when referencing a subform control I do it from the main form and I can't get my head around calling a subform control from the very subform control I am calling. Doesn't feel like it could work, but I am really not much good with VBA so my feeling really doesn't count for very much. Sorry if I am not explaining myself particularly well or if I am misunderstanding what you are saying.

[Rabbit]

Is this RowNum a custom function? I can't find any reference to it in the Visual Basic 6 documentation.

[Rob Amor]

I actually found it on this forum in another post. It suggested using =RowNum([Forms]![MyFormName])in an unbound textbox to number records, and that's about all I know about it. Works a treat until the form becomes a sub form. Certainly if you type rownum into the control source box in the textbox properties it appears as an autocomplete option as a function. Does that shed any light?

[Rabbit]

Still can't find a reference to it. I wonder if it's a part of a third party library. Try using the intellisense to see if there's any documentation on it.

[Rob Amor]

Had a look and I can't find anything which sheds any light on the problem. Tried searching the internet again and found nothing that helps there either. Maybe it just can't be used in a subform? Maybe time for me to look at an alternative method? Thanks for your Help Rabbit I appreciate your time and input.

[Rabbit]

Not a problem, sorry I couldn't be of more help. If you want to try an alternate method, please create a new thread for that so that we can start fresh.