Hello,
I currently have a form that presents options to a user. Based on those options a subform is opened. I would like to present that subform (insert it if you will) into a subform (DM) in that original form. I want to present the data like this as there are many possible combinations of the output data.
I am developing a conditional statement and trying to insert the subform by adding the following to the code.
If This = "stuff1" And That = "Stuff2" Then
DoCmd.OpenForm "output1"
Set dbs = CurrentDb
dbs.Execute " INSERT into DM " _
It will not insert the subform into "DM"
I am missing something or do I need to go in a different direction with this?
Thank you for any advice you may have.
Rick
I currently have a form that presents options to a user. Based on those options a subform is opened. I would like to present that subform (insert it if you will) into a subform (DM) in that original form. I want to present the data like this as there are many possible combinations of the output data.
I am developing a conditional statement and trying to insert the subform by adding the following to the code.
If This = "stuff1" And That = "Stuff2" Then
DoCmd.OpenForm "output1"
Set dbs = CurrentDb
dbs.Execute " INSERT into DM " _
It will not insert the subform into "DM"
I am missing something or do I need to go in a different direction with this?
Thank you for any advice you may have.
Rick