How to make a Add button to add new controls in the form

  • Thread starter Thread starter Bon
  • Start date Start date
B

Bon

Hello all

I want to create a Access 2000 form with a ADD button. My idea is: when
the user click the Add button, controls will be shown. Then, the user
can select the options in drop down list box and type in some data in
the text box. Afterwards, the entered information will be saved into
the SQL database. If the user click the Add button again, a group of
new controls are shown.

The controls are:
DropDownListBox1 DropDownListBox2 Textbox1 DropDownlistBoxx
DropDownListBox

I am a newbie in Access and Access VBA. Could you give me some
suggestion on how to do it?

Cheers
Bon
 
Bon said:
Hello all

I want to create a Access 2000 form with a ADD button. My idea is:
when the user click the Add button, controls will be shown. Then, the
user can select the options in drop down list box and type in some
data in the text box. Afterwards, the entered information will be
saved into the SQL database. If the user click the Add button again,
a group of new controls are shown.

The controls are:
DropDownListBox1 DropDownListBox2 Textbox1 DropDownlistBoxx
DropDownListBox

I am a newbie in Access and Access VBA. Could you give me some
suggestion on how to do it?
Click to expand...

This is not an appropriate use of an Access form. Access forms have a
lifetime limit on the number of controls that can be added and you would
quickly hit this limit using this strategy.

Is there a reason you can't use ONE set of controls and just clear them
between entries?
 
Back
Top