Updating table from combo box + clearing fields for new record

[Focusfocs]

Hello,
I have a form that contains a combo box which auto fills 3 other text boxes. My question is how do I update a table from the fields that the combo box supplies? Also how do I rememdy adding a new record and having the combo box 'reset' the fields to blank when a new record is added? The combo box fields run on 1 table and I am to update a different table entirely...
Thanks so much!

 

[TheAceMan1]

How are ya Focusfocs . . . . .

If you bind the form to the table (be sure to include the [purple]primarykey[/purple]), all you have to do is use the navigation buttons to [blue]goto a new record[/blue]. The fields are [blue]automatically saved[/blue] and the new [blue]record is cleared[/blue].

Note: [purple]This is standard operation for a form![/purple]

See Ya! . . . . . .

 

[Focusfocs]

Yes, I know what you're saying and that does work...But what I am trying to do is to automatically fill 3 fields from a seperate table; that is why I'm using the combo box- I am autofilling the fields by using the comboboxes after update event. I am adding a clause which will update my my ain table with that info that has been selected in the combo box. The form is already bound to the main table via the record source. I need to update 1 table yet have ALL fields from both tables appear as a new record. I need a way to ensure that when a record is added, all fields appear blank....