Dave Ashish method of updating from previous record

Hi Marshal,

You have been very kind.
I wish I could put this on hold. I cannot.
But thank you for your very kind comments.
I will find a way to accomplish it. I always do.

Thanking you
Leo

"Marshall Barton" wrote:

Leo wrote:

Marshall, I did understand that and has recovered from it. Now the problem I
need to solve is this.

I don't want to set the default value globally so that when a user enters
the value that value is carried to all the individuals. I need it to be
specific for that individual so that anytime a form is open for that
individual his/her values are automatically updated from the last entry. It
should also not change the values of that individual's prior records. Each
individual will have one record for each month. (Each individual also has an
Id number that is being automatically inserted into this form since it is a
subform). Any way this could be accomplished.


Well, there usually is a way to all kinds of things, but
some things are more complex than others. Because
DefaultValue is a property of the text box, it has no
connection to some other information in other records (ie.
the individual)

That means you would have to create a way to determine the
individual and the default height you want to use for the
individual. I think that can be done by having a table with
one record per individual and adding a field for the default
height. Then you could use the form's Current event to
retrieve the default height field from that table and stuff
that into the text box's DefaultValue property. With the
default height in that kind of table, it would probably be
easier to join that table to the table you have now to make
the default height a field in the form's record source
query.

At his point I am not convinced that the DefaultValue
property is really helping here. You could just use the
form's BeforeInsert event to retrieve the value and stuff it
directly into the value property when a new record is being
created. OTOH, considering how new you are to all this, you
may want to put a hold on this particular goal until you
have a firm grasp on using VBA code.

--
Marsh
MVP [MS Access]
.