Creating a Mileage Log

[Tonytitan]

I am attempting to create an Access 2003-based mileage log with data
generated by a Palm Treo application (Trip Deluxe). I have it almost
completed execpt for one feature. I need for my destination (address, city,
state) to become my departure point on my next entry. Unless someone has a
better suggestion, it looks to me (and my very limited Access experience)
that I need for this to take place during the OnFormat event. What I think
needs to happen is that the record pointer needs to advance to the next
record in the query (I have two tables inner joined) retreive the
destination, return to the current record and load that data into the fields
set up as the departure point, and then print the current record. I think my
method is sound; I just don't know how to code it. Any help would be greatly
appreciated.

 

[PC Datasheet]

The simple way to do this is when you enter your destination set the default
values for departure equal to the destination values.

 

[Tonytitan]

Forgive me for not being more thorough in my description of the process. I
think that your response assumes that I am using Access to enter data, which
I am not. All data entry takes place on my Palm Treo using Trip Deluxe and
the built-in Contacts application. When the Treo is Hot-Synced with my
laptop, the Trip data is loaded into an Excel spreadsheet and eventually
imported into Access as a *.csv file into a table named Trip. The Contacts
info is transfered into Palm's Desktop app and exported into another Excel
spreadsheet, also in *.csv format. After another import, this data ends up in
a table called Locations. This is the source of my address information that
alternates between departure and arrival points. Correct me if I'm wrong, but
it seems that your solution gives me matching departure and arrival points
for each record printed, unless the OnFormat event is the wrong place to
implement this. Once again, thank you for your time and attention.