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

saving subforms value

P: 32
hi all,

How can i get a subforms value to save into a table?

the table only has 1 entry, so it should edit itm rather than add a new one
May 19 '07 #1
Share this Question
Share on Google+
2 Replies


JConsulting
Expert 100+
P: 603
hi all,

How can i get a subforms value to save into a table?

the table only has 1 entry, so it should edit itm rather than add a new one
currentdb.execute "update yourtable set field ='" & me.mytextbox & ";'"

put this on a click event or button on your subform. Change the names to yours.

J
May 22 '07 #2

NeoPa
Expert Mod 15k+
P: 31,342
hi all,

How can i get a subforms value to save into a table?

the table only has 1 entry, so it should edit itm rather than add a new one
Bind the form to the required table (RecordSource --> TableName)
Jun 2 '07 #3

Post your reply

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