Add Data to subform

  • Thread starter mattc66 via AccessMonster.com
  • Start date
M

mattc66 via AccessMonster.com

Hi All,

I have a drop down box that I have set the after update event to add data to
a subform. However it adds the data to the first record on the subform. How
to I code it so it add the data to a new line on the subform?

Thanks
Matt
 
M

mattc66 via AccessMonster.com

Here is my current code. What happened when I ran is it over wrote the first
record of data.

DoCmd.GoToRecord , , acNewRec ' Perform some action.
Form!sfrmToQCLog![PO] = cboLookupPO.Column(0)
Form!sfrmToQCLog![ITEM] = cboLookupPO.Column(1)
Form!sfrmToQCLog![VENDOR] = cboLookupPO.Column(2)
 
Top