By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,461 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,461 IT Pros & Developers. It's quick & easy.

Saving data from a form to a table

P: 2
This is probably pretty easy, but I am new user of Access. I created a form where people enter data into certain fields and when they are done entering the data I want them to be able to click a button which then saves or records everything they just entered into a table and then they can continue entering different data. What is code behind this and what is the easiest way to accomplish this, any help would be great.

Thanks,

Justin
Sep 25 '06 #1
Share this Question
Share on Google+
3 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,

Are you sure that you need a Save bouton?

Access do it instaed you!
Sep 25 '06 #2

P: 2
Maybe I didn't describe my situation properly. It is not as simple as pushing the save button in the file menu. How do I direct where the data in the fields entered in the form go? Everytime someone enters data in the form and push this "Save/next record" button the form clears and someone can enter new data. I know in the command button menu there is a save record function and next record function, is that what I should use?
Sep 25 '06 #3

PEB
Expert 100+
P: 1,418
PEB
In fact each form has Record Source property! To see this property click in form design on the properties bouton or click with right bouton and choose properties!

Unsure you that you have choosen the FORM properties coz there are a lot in Access

So one of the first properties are Record source properies..

It's just there that you say where your data have to be stored...

And you fill in your form with fields from this source...

This what you want it's web based manner and it's good when you have more than 10 billions of records! And the Save bouton is very very helpful thing!

But I hope that in your case you want to manage a database till 100 000 records...

So the users haven't to care about the saving of record! They have to go to the next record or previous... No save, no more!

:)
Sep 25 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.