Default value = last selected value

[JoeyJ]

Hi All

I am trying to make a form where the default value of particular fields is the last value that was selected for that field. This is to make it faster to enter data.

I have never done this before and am only taking a guess, this is what I have done so far:

For the AfterUpdate property, I have entered Me![Field Name].Requery
For the default value property of the same field, I have entered [Forms]![Form Name].[Field Name]

When using the form, I get #Error as the default value.

Can anyone provide details on how to get it to work?

Thanks in advance

Joey

 

[RuralGuy]

Maybe this link will give you some ideas.