Save to table?

[option]

Here we go again!

This one should be simple for you guys: I've got a form that requires the user to input the missing information. Some text boxes are pre-populated due to a combo box. My issue is how would I save the information that is entered into a new table? I'll upload the db so you can follow along.

For instance, on the form EmpDoc, choose Agent ID 12345. John Smith and all of his info appears. Now it's up to John to fill in the rest. Once that is done, how can he click a button to save all of that info to the PrintTable table? This is probably gonna be so easy, but I have a habit of making things more difficult than they need to be hahaha.

 

[The_Doc_Man]

Your use of "new table" is confusing here. Let me ask a question by way of clarification.

Are you saying that you have a form bound to table A, but when someone opens up a record and populates it you want that data to table B ?

If that is correct, you need to use VBA and recordsets, because otherwise the natural tendency of Access would be to save to table A (in my description above.) I.e. Access "wants" to store in the table to which the form is bound.

If there is a mis-communication then you need to be slightly more specific in what you want to do.

 

[option]

You've hit the nail on the head my friend! As far as record sets, I haven't toyed with them as of yet since i don't know how to. But VBA...I'm slowly coming to grasp that. Any ideas to point me in the right direction? (sorry to ask so much!)

 

[dkinley]

Other than a bookstore with tomes of reference manuals ...

http://www.functionx.com/vbaccess/Lesson01.htm

is a pretty good start. You should be able to find BlueClaw from there, they post some pretty good examples, too.

-dK

 

[khawar]

Download the attached db is this what you want to do

 

[option]

That's exactly what I needed! Thank you so much!!