Prev: Need null values for several fields in db
Next: Convert to Proper or Title Case in Access 2003
From: Leo on 1 May 2010 00:10
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]
> .
>
First  |  Prev  | 
Pages: 1 2 3
Prev: Need null values for several fields in db
Next: Convert to Proper or Title Case in Access 2003