Updating from Form to Table (Mulitple fields)

[Guest]

Hi
I have a table with following fields
-Currency
-Currency code
-Action date
26 currencies are added to the table, and Action date field is empty.
I need to update all the 26 fields (in Action date) with a date, from a form
(user input)
Form Name : Currency Input
Field Name : COB (DATE FORMAT)
By inputing COB need to update all the fields of the currecy table
*Actiondate*
In other words Action date = Form!COB

Please help

Thanks

 

[Guest]

in the after update event of the COB field add the following code

DoCmd.RunSQL "UPDATE [Currency Table] SET [Action Date] = #" & Form!COB & "#"

 

[Guest]

Thanks Dennis, helped me lot of time, by the by please suggest me a book
where i can have this do cmd sql examples.

Thanks
rony

in the after update event of the COB field add the following code

DoCmd.RunSQL "UPDATE [Currency Table] SET [Action Date] = #" & Form!COB & "#"

Hi
I have a table with following fields
-Currency
-Currency code
-Action date
26 currencies are added to the table, and Action date field is empty.
I need to update all the 26 fields (in Action date) with a date, from a form
(user input)
Form Name : Currency Input
Field Name : COB (DATE FORMAT)
By inputing COB need to update all the fields of the currecy table
*Actiondate*
In other words Action date = Form!COB

Please help

Thanks

 

[Guest]

This is in the normal Access Help. Look under DoCmd or RunSQL

Thanks Dennis, helped me lot of time, by the by please suggest me a book
where i can have this do cmd sql examples.

Thanks
rony

in the after update event of the COB field add the following code

DoCmd.RunSQL "UPDATE [Currency Table] SET [Action Date] = #" & Form!COB & "#"

Hi
I have a table with following fields
-Currency
-Currency code
-Action date
26 currencies are added to the table, and Action date field is empty.
I need to update all the 26 fields (in Action date) with a date, from a form
(user input)
Form Name : Currency Input
Field Name : COB (DATE FORMAT)
By inputing COB need to update all the fields of the currecy table
*Actiondate*
In other words Action date = Form!COB

Please help

Thanks