Save form data into a different table?

[ChrisNeal1990]

Hi Guys,

I'm attempting to put together a Call Pegging database and myself being a bit of a novice am stuck pretty early on unfortunately.

I have a form with 2 combo boxes, combo box 1 = Primary call type, combo box 2 = secondary call type. The combo box values are pulled from 2 seperate tables (tblprimary & tblsecondary). What I want to happen is when a user completes both combo boxes the data then saves that as a new record to the call pegging table.

Can this be achieved at all?

Thanks in advance

Chris

 

[ChrisNeal1990]

Apologies, just realized I posted this in the queries category opposed to the forms catergory.