Re: Changing the Value of a Field in a Bound Form

On Tue, 31 Jul 2007 12:12:52 -0000, prakashwadhwani@xxxxxxxxx wrote:

I have a continuous form bound to an underlying table.

How do I change the value of one field (all rows) to a particular
constant say eg. 1998.

Someone on the Group here mentioned I should not use a the RunSQL
command to modify a bound form.

Why not?


If so, what are my alternatives ?

It's like asking someone "What time does the plane leave?"
Well it would be nice to know where you're going, On what day? etc. as
there are many planes to many places.

Do you mean you wish to change the value of one field in ALL the
records in the table?
When/why do you wish to do this?
Using the Click event of a command button?

Dim strSQL as String
strSQL = "Update YourTable Set YourTable.FieldName = 1998;"
CurrentDb.Execute strSQL, dbFailOnError


--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Quantcast