DefaultValue in form taken from last record

E

El Tel

Hi,

I'm probably askin gthe obvious but I've been picking this
up and putting it down again so often that I can't see the
wood for the trees...

A very simple 4 field data entry form, first two fields
are drop down. The typw of data that is to be entered
will be in groups of similar records so I would like the
first two fields to have the DefaultValue set to the same
fields in the previous record. The ides is that the user
doesn't have to select the same items again and again.

Thanks,

ElT
 
T

Tim Ferguson

The typw of data that is to be entered
will be in groups of similar records so I would like the
first two fields to have the DefaultValue set to the same
fields in the previous record.
Click to expand...

From the data point of view, there is of course no concept of the previous
record.

On the other hand, if you just want the form to remember what the user did
last time, you can set the DefaultValue property of the control(s), in the
BeforeUpdate or AfterUpdate event...

HTH


Tim F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Split form 0
Copy previous record into form field 0
How do I clear a form? 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0
How to set focus on a new record in a datasheet 1
Repeat fields from last record 3

Top