I have a field called "Model" in my parent form. Based on the "Model" the user chooses I would like to populate the "Options" field in my subform. When the user chooses an "Option" from the subform, I would like the "Unit Price" for the "Option" to display in the "Unit Price" field. How do I do this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Populate a combo box in a subform from a field in the parent form?
- Thread starter Sarah28
- Start date
In the Model "After update" event you need VBA code.<br>Since you did not say where the "Options" data is coming from. I have to guess.<br><br>If its from a table then you can create a combox box using the Wizard and then edit the SQL code it generates to look at the "Model" field and have a .Requery in the "After Update" event.<br><br>SELECT DISTINCTROW Options, FROM YourTable WHERE (((Model)=[Forms]![Your form]![Model]));<br>I don't know if I have the correct fields in the above SQL.<br><br>Private Sub Model_AfterUpdate()<br> YourCombo.Requery<br>End Sub<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
- Status
Similar threads
- Locked
- Question
