saving subforms value

[micksitup]

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

[JConsulting]

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.execu te "update yourtable set field ='" & me.mytextbox & ";'"

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

J

[NeoPa]

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)