Re: default vaule in form

[ecsrs]

I have a form with 8 fields in it. I was wondering if I can have the first two fields (date and employee) automatically default to the previous record when I start a new record. It would make the data entry process easier.

 

[hneal98]

The only way I can think of off hand is by having another table to store that data and have those fields be based on that table. Then have that table updated through VBA when you make whatever changes.

 

[janetlyn]

I know it has been awhile since your post, but since you did not post back that you found the answer (and the answer for everyone's edification) here is the answer to a post I found that will work for what you are asking:

http://support.microsoft.com/default.aspx?scid=kb;en-us;210236&Product=acc2000

This is obviously Microsoft Knowledge Base, Article 210236, in case my fingers did not type the address correctly. Good luck. JL