aPPEND THE TABLE OFF THE FORM

[BorisGomel]

Hi everybody ,

I am working with large Access database and I need to keep record of QB invoices. The problem that is qb invoices have been updated right into very large table called Summary 2012 off the form . I type onto text boxes txtDate and txtQbInvs on form and click the comand buton that excecute the updating. There are four types of invoices:nsf,direct,gross and cost.I create table called QB2012 with five fileds in it :gross,nsf,direct,cost and dateQB and how can i append QB invoices accordinlgy what I type in text boxes on the form to the table QB2012


Thnak you in advance,
Best Reagards,
BorisGomel

[TG_W]

If the information is already in the table Summary 2012, then why noot just query the QB invoice information?

Another option would be to link the table to the form.

Hope that helps.