Just got in mind to try & create a user input form for a datalist.



My idea was to type in a row of headings ie, LastName, DOB etc

Type in the following row with prefixed control names,ie txtLastName, dteDOB
etc

And then run a procedure to automatically create a "draft" userform which
you can then customise.

The procedure to "Identify" the type of field by the fieldname prefix.

To be added would be a "Add", "Cancel", "Close" buttons.



With the expertise that this forum has, I am sure somebody has already tried
something similar, but I couldn't find anything in the archives.

Does anybody out there know where I could find such a procedure