I need to be able to dynamically (programmatically) create ‘X’ number of Command Buttons on a form based on data in a table. (e.g. if the table contains 10 records, I need ten Command Buttons with the LastName field shown as the caption on the button) I (think I) know this involves creating and using RecordSets and MoveNext, MoveFirst commands etc.
Is there a SIMPLE tutorial on creating and using Recordsets? (I’ve been through the Access VBA Help – no help – that’s why I’m asking here!)
Also, any help (code examples?) with my specific problem would be GREATLY appreciated.