Prepopulate subform with multiple records

[Erik Feenstra]

Hey there,

I'm struggling with the following challenge. I have a mainform with header information and a subform with details (datasheet view). Based on the value of a mainforms' combobox I would like to prepopulate multiple records of the subform so the user can add/modify the values for the 3rd column (please see attached image). Does anybody know how to do this?

Thanks so much!

[TheSmileyCoder]

In the afterUpdate Event of the combobox, you would need to add code to insert the values into the relevant table, and then requery the subform.