Hi!

My project relies heavily on data forms, so I decided to build a data ActiveX which will consist of two forms. One will be the main interface with five buttons (First, Previous [Record # of #] Next Last New) with text field in the middle, and five more buttons on the right side allowing to edit the current record, delete, find, cancel or save. The behaviour will be much like in the data forms produced by the data form wizard. In fact, I want to build the ActiveX based on the class generated by the wizard. The only problem that I am facing is that the class has all the Property Get and Property Let procedures defined for each of the fields in the recordset, but because my ActiveX should work with any recordset, how do I expose each of the fields to my applications?

The second form in the ActiveX will pop up when the user presses the Find button. The Search will display hits in a listbox and upon double-clicking the listbox the form will be closed and the ActiveX will be repositioned to the chosen record.

How do I solve this problem? I think it would be awkward to always use the wizard to generate data-access classes and although this is the OOP approach, it's not really reusable.

Thank you very much for your help!

Stanislav