Add new record to subform

W

Winger

I've looked through previous threads, tried some examples, but can't get this
to work - so I'd thought I ask my own question.

I have a MainForm that scrolls through a list of NewsItems that have been
received, and a Subform that shows for each NewsItem the list of people that
it has been forwarded to.
The MainForm has a Combobox with a List of New People, so I want to scroll
through each Newsitem on the MainForm, look at who has received the item in
the Subform and if I want to add a new person to the list, I'll select them
from the Combo on the main form and create a new record in the subform.
The new record should contain the ID of the newsitem from the MainForm and
the person name from the combo box on the MainForm.

The code should therefore do the following-

On Click of Command Button on Main form, Add new record to Subform, where
fieldNewsID onSubform = NewsID on main form and fieldPerson = Person from
Combo box on MainForm.

I've tried AddNew, Recordset Clone etc - but its all a mess!!

Any help or pointers would be gratefully received.

Thanks

Winger
 
Top