How to create Auto Regenerating Dropboxs in data entry forms

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.
 
K

Klatuu

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box that once item is selected, a new combo box appears 4
Data Entry Form Changes Dependent On Drop Down 3
Auto partially populate form 1
Data entry for a table from a form 1
Is it possible? 9
CALCULATED VALUES IN A FORM BASED ON USER DATA INPUT 3
Using a Query in a Form 4
Totals on a Form 4

Top