NotinList Happy Happy Joy Joy

[khunter]

I am using the notinlist event to ask the user if they would like to add new info into the underlaying table. If they do, it opens the form based on the underlaying table.

My issue is i would really like to pass the contents of the combo box to the new form via openargs.

I have read many examples from this forums and tried them to no avail. I can pass the cbo contents to an unbound control but I want to pass it to the table for update.

Blah.

Thanks,

 

[mresann]

In the After_Update event of the combo box in the VBA module, use the DoCmd.RunSQL command to process an Update or Append query to enter the data. The query can be built "on the fly" from the parameters you wish to use.