How do I automatically default to previous record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like the default value to equal the previous record, except if a new
value is typed over it. How do I write this expression?
 
Create a macro for the "On Got Focus" property using SetValue. Simply click
on the text box that you wish to have the record imported to, open the
properties box, select "On Got Focus" from the event tab and click on the
button with the three dots. Select Macro. In the action column enter
"SetValue".

At the bottom of the page you will see "Item". This is where you enter the
name of the control where you want the information to appear.

"Expression" is where you enter the location the information is to be taken
from.

Simply save and you're done.
 
Thanks, your response is very helpful so far. However, I am unsure how to
tell the expression to take the previous record.
 
Are you looking to take the information from a table or from another
control on your form. For example: Are you looking to have a shipping
address default to a previously entered billing address?
 
I am creating daily forms. One section is the 'contacts' that is a data entry
form direct to the contact table. The 'Supervisor on site' should be the same
each day, but lets say the assigned supervisor is sick, a new supervisor
would be assigned. Therefore, I would like the previous day supervisor from
the contact table to be repeated daily unless the user types over it. I'm
looking to take information from the same table.
 
It sounds to me as though you are simply looking for a "default" supervisor
(Smith). Is that true? If so, open your form in the design view, double-
click on the supervisor control, click on the data tab and enter the name
of the supervisor you would like it to default to (Smith)in the "Default
Value" property.

When you go to the data input view, Smith should be the day's supervisor.
When it is on focus, you have the option of retaining it or typing over the
default (Smith) with whoever (Jones)

Hope this helps - John
 
Thanks for your assistance. This suggestion would work great for tracking
only one site. I have a database of multiple sites, with a different
Supervisor at each site, so in this case, there is no unique default name to
put in the properties default value. I need to figure out how to default to
the previous days Supervisor for each individuale site on a daily basis. Any
ideas for this?
 
John,

I am looking exactly for how to do your example. Do you know how to do it
in Access. I want the user of the form to click a button if the shipping
address is the same as the billing and the shipping address automaticaly
populates. Otherwise the user enters the different shipping info. Any help
would be great.
 
Back
Top