Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
I have a VBA function returning an ADODB.Recordset of 5 columns wide by however many rows deep (probably not more than 50 records at any one time). I would like to return this recordset to a DataSheet style Form so that users can review the data and make amendments as required.
How do I do this? Do I need to place controls on the Form and if so do I have to create a text box for each field for each record?
Thanks for any help!
How do I do this? Do I need to place controls on the Form and if so do I have to create a text box for each field for each record?
Thanks for any help!