Duplicate value

[Borgarn]

Hey.

I'm sort of new to this.

1.
I am making a logbook and in that one I have Two feilds one called "Departure place" and one "Arrival Place".
For now all the Departure and arrival places are the same, but maybe not in the future. How can I do so the Arrival copies the info from Departure?

2.
I also want the Departure place copied from the last entry in the row before from.


Best Regards Borgarn

[Micron]

Set the row source for the textbox for Departure to a query or sql statement that gets the Departure value WHERE the ID is Max of the ID field (I presume you have an autonumber field at least, as a unique row identifier). Also, in the property sheet, make default value for textbox for Arrival = Departure.