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

Add data from a form into a table!

P: n/a
Hi,

i need som help!!!

I have a form wich a user type some new data in! And when he/she hits
the 'Add' button... i want the data on the form to fly straight into
an existing table!!

Please send some example....

Thanx in advance...
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Just build a form. In fact, use the wizard.

You can then place a buttion on the form, and behind the buttion, place the
follwing code:
if me.dirty = true then
me.dirty = false
end if

The above will send the data to the table.

Do note, that if the user navigates to another record, or even closes
ms-access, or even closes the form, the data will also be sent to the table
for you, and you don't need ANY code for this to happen.

And, if the user adds a new record, the data is also sent to the table. So,
ms-access does handle this automatically for you, but if you must, you can
use the above code behind button, and when the button is pressed, the data
will be sent to the table...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.