ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   User form controls add (https://www.excelbanter.com/excel-programming/299503-user-form-controls-add.html)

nath

User form controls add
 
Hi

I am using the code below to add controls to a form based
upon what the fields they relate to in access. i.e. With
a SQL rowsource, they have a combo box, normal they just
have a text box. This works fine.

EvoDataForm2.Controls.Add "Forms.textbox.1", ("Fld" & h),
True

What i need to do now is to add these controls in a
similar way, but on a multipage. I am sure it wont be
that much different in relation to code, but i just cant
figure it out.

TIA

Nath.

nath

User form controls add
 
ITS OK I HAVE DONE THIS NOW.

THANKS ANY WAY

NATH
-----Original Message-----
Hi

I am using the code below to add controls to a form based
upon what the fields they relate to in access. i.e. With
a SQL rowsource, they have a combo box, normal they just
have a text box. This works fine.

EvoDataForm2.Controls.Add "Forms.textbox.1", ("Fld" & h),
True

What i need to do now is to add these controls in a
similar way, but on a multipage. I am sure it wont be
that much different in relation to code, but i just cant
figure it out.

TIA

Nath.
.



All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com