How to create Auto Regenerating Dropboxs in data entry forms

  • Thread starter Thread starter Andrew Hollis
  • Start date Start date
A

Andrew Hollis

I'm trying to create an auto generating drop box on a data entry form. That
is, someone would be entering data that may pertain to more that one project.
I'd like to have a drop down menu that, once a value is selected from it, an
exact duplicate appears underneath, and the user can enter as many projects
as are associated with that data. I'm not sure how to do this.
 
Make your combo box an unbound control. In the After Update event of the
combo, set the Default Value of the control you want to populate to the value
in the combo.

I am assuming the combo is on the main form an the control to populate is on
the sub form:

Private Sub cboProjectID_AfterUpdate()

Me.MySubformControlName.txtProjectID.DefaultValue = Me.cboProjectID

End Sub
 
Back
Top