If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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] . |
|
Thread Tools | |
Display Modes | |
|
|