transfer value to subform new record

i've been wrestling with this one....
i have a listboxA on a mainform and a button next to it
i want on click to transfer the value from listboxA

to a NEW record on the Subform

how do i specify that it goes to a new record?

thanks for any help on this, J
jfgkAsked:
Who is Participating?
 
DarkMorConnect With a Mentor Commented:
jfgk,
Is the subform in FORM  or Datasheet/Continuous, also are there other fields on the subform that need data before the record can be saved, finally can the user cancel saving the record after clicking the button.

The reason I ask these are to better help understand the scenerio.

It is possible to docmd.gotorecord, , nacnewrec on the subform and then set the value by referencing the listbox value, however knowing the structure of the subform makes a big difference

D
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.