Want a running count of record number on continuous form

[DanEaton]

I have a search form that matches control's values with an underlying query. The unbound search comboBoxes are in the form header, and there are continuous results in the 'detail' section. Some people at work have complained that they get confused about what record they are at when they scroll down. I have four fields that are displayed in each record, and they up quite a bit of space. I suggested that a sub-form in datasheet view might work better, but they were dissatisfied with the aesthetics. ANYWAY, what they would like is just a box that displays each record number beside the controls in each record. Like say a text box with a 1 in it for the first record, and so on...Is there a function in VBA that will accomplish this task?

They are also unhappy that I don't have anything that tells them when "there are no search results". Is there a function that can be used that would accomplish this task in an "if" statement, if there are no matching records?

Thanks. Dan Eaton
deaton@caemachinery.com

 

[thornmastr]

Dan,

I started playing with this last night looking for a way better than the way I have used with clients who are as obtuse as yours and no luck. The problem is that unless you can attach your counting variable on the form to a corresponding table column, it will never work properly; not the way continuous forms currently work.

If you will drop me a note, telling me what version of Access you are running, I will be happy to zip you a sample of how it can work.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com