Who can solve my Access Form coading problem ?

  • Thread starter Thread starter Access form problem
  • Start date Start date
A

Access form problem

I am a sales executive . I have to make several visit in a day at different
customer's places .As per my requirement , i have created an small
application to keep database of my visits . I created an table named VISIT &
a auto form in access . The field in my form are DATE(Auto field),
FROM-(Starting point), TO(Destination Point) .Every thing is fine . I make
entry once in a day . Date appears automatically . Then i start with FROM &
TO . My second starting place is last destination . Ex I started from Visit 1
(A to B ) then Visit 2 (B to C )........Visit N (...to A) . I want that when
i make entry for Visit 2 then FROM field should pick the data from Visit 1 ie
B .
 
I am a sales executive . I have to make several visit in a day at different
customer's places .As per my requirement , i have created an small
application to keep database of my visits . I created an table named VISIT &
a auto form in access . The field in my form are DATE(Auto field),
FROM-(Starting point), TO(Destination Point) .Every thing is fine . I make
entry once in a day . Date appears automatically . Then i start with FROM &
TO . My second starting place is last destination . Ex I started from Visit 1
(A to B ) then Visit 2 (B to C )........Visit N (...to A) . I want that when
i make entry for Visit 2 then FROM field should pick the data from Visit 1 ie
B .
Click to expand...

1) Date, From, and To are reserved Access/VBA/Jet words and should
not be used as field names.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'

For an even more complete list of reserved words, see:
http://www.allenbrowne.com/AppIssueBadWord.html

2) Assuming both [From] and [To] are Text datatype fields:
Code the [To] control's AfterUpdate event:

Me![FromControlName].DefaultValue = """" & Me![ToControlName] & """"

You will need to enter the From value once per session. Once you enter
the To value, it will become the default value for the next record's
[From] entry.
 
Back
Top