updating the value of a field

  • Thread starter Thread starter Phil Boorman
  • Start date Start date
P

Phil Boorman

Is there an easy way to have a field in a form update that same field on the
table it was derived from? I have a table of swimmers that includes a field
indicating their swim level. On the form that populates this table the Swim
level field is a combo box that takes it's info from a simple table of swim
levels. I would like to have another form that has nothing more on it than
the swimmers name, their previous (or existing) Swim level, and a field for
their new level. I would like the field for the new level to update the
Swimmers table with their new swim level. This "move up" form would be
quicker than searching through the "swimmers" table and changing it and
would also keep a seperate record of swimmers who have changed levels.

I used the "create form" wizard and based it on the swimmers table. I
dragged the name field onto this new form, added 2 combo boxes with a row
source of the swimmers table(followed by the "swim level" field) and then
when prompted to either remember the value or store it, I selected to store
it in "swim level". It does not change the value of the "swim level" field
in my swimmers field however.

Am I on a completely wrong track?

Thanks,

Phil
 
Is there an easy way to have a field in a form update that same field on the
table it was derived from?
Click to expand...

That question presupposes that you can store data in a Form, or in a
Table, or in both. That assumption IS SIMPLY WRONG.

A Form *has no fields*. A Form is just a window, a tool that lets you
store and edit data in tables. The data exists in the table *and only
in the table*. A Form has Controls (not fields); you can temporarily
display data in a Control on a form. If that control is bound to a
table field, by its Control Source property, then simply typing data
into the Control will store it in the field.
I have a table of swimmers that includes a field
indicating their swim level. On the form that populates this table the Swim
level field is a combo box that takes it's info from a simple table of swim
levels. I would like to have another form that has nothing more on it than
the swimmers name, their previous (or existing) Swim level, and a field for
their new level. I would like the field for the new level to update the
Swimmers table with their new swim level. This "move up" form would be
quicker than searching through the "swimmers" table and changing it and
would also keep a seperate record of swimmers who have changed levels.
Click to expand...

You can do it more simply than that! Simply use the Combo Box on the
for displaying the swimmer's swim level; select a different swim
level; press <enter> or <tab> and you have now updated that swimmer's
swim level. Having a separate form and writing code to update it can
be done, but it's going all the way around the barn to do something
very easy!


John W. Vinson[MVP]
 
Back
Top