Dynamically creating a form from table values

[SteveJR]

Hi,

Have searched on the forum but cannot find any previous questions like mine so here goes:

Can anyone tell me how to create a form in VBA and add textboxes to it where the value in one column from the table is the textbox caption and name and the value in another column is the value displayed in the textbox.

Any code/pointers that can provided would be much appreciated.

Thanks,

Steve

 

[Rolliee]

This should be no problem. Send me your email address and I will whip up a sample for you.

rollie@bwsys.net

 

[SteveJR]

Hi Rollie,

Email address is stevej@oxted.eclipse.co.uk. Anything that you could provide would be great.

 

[MichaelRed]

see thread705-481652. It includes a 'more-or-less' complete procedure for doing the CreateReport function nad populating it with the fields from a table. To do the CreateForm, which is 'the same' as CreateReport (they 'share both the method and example in {F1}).




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[SteveJR]

MicahelRed,

Thank you so much for the link. A few amendments and I'll be in business!

Thanks again,

Steve