Dynamic Default Values

[Wizardx8]

Hi everyone, I am relatively new to MS Access and databases in general, so hopefully this can be solved easily...

I am creating a table where data will be inputted directly, not through a form... I am trying to set up so that the default value of a certain text field, will be whateever was entered into the previous record...

eg.

Say in Record1 I enter "string" in Field1, When I go to enter a new record I would like Field1's default value to be "string"

Is this possible? If so how do I go about doing it please...

Thanks

Wiz

 

[bradcccs]

Wiz,

I would recommend creating a form for data entry. This will then enable you to achieve exactly what you want.
(Not to say it can't be done in a table - I just don't know how (or why) it would be done).

Data entry into a table directly is limited.

You could construct your form to appear as a table if that is your concern.

Brad.

 

[Wizardx8]

Brad, thank you for the advice... OK I have convinced the client to use a form for data entry...

Now how would I set this up in a form if you don't mind me asking, I really am pretty new to all fo this...

 

[bradcccs]

Wiz,

Now we complicate the matter and say it can be done several ways, depending on your requirements.

I have read a few interestings posts on this matter.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=18210

I have not used the above method myself, but thought it an interesting approach.

Trying searching for other posts if this is not the approach you are after.

Brad.

 

[Wizardx8]

Thanks Brad, an interesting approach to be sure... Have come up with what I think may do the trick though...

Have a simple query that finds that one cell... In the form have the default value use an expression that uses the results of that query... This is all a bit beyond me but will see what I can do, thanks for the tip

 

[Lyn Mac]

Another approach

Try this on the GotFocus event of the control:

SendKeys "^(')" 'Ctrl + '


When the control has the focus the code will execute and the value of the previous record in this control will be copied.


HTH,

Lyn