[MS_AccessPros] Moving Select Data from a Form to a Table

 

Hi,

I have a simple item database used to do a year-end inventory and pricing. There is a form I use to update the items with current price and last po# and date. I would like to take information from this for and add it to a different table to keep track of purchase history. The new table has the fields: AUTOID, ITEMID, COSTREF, COSTDATE, and COST.

I would like to add a control button on the form to add the data from the form txtBoxes (txtITEMID, txtCOSTREF, txtCOSTDATE, txtCOST) to tblCostHistory, but I'm not sure how to code it. Also, the AUTOID in the table is an AutoNumber field to make sure there is no possibility of EXACT records. If I create a new record through the code in the form, will the AUTOID field still advance?

Any thoughts or suggestions would be greatly appreciated.

Thank you,
JerseyDiver62

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___