Mileage App

[neo651]

I have an existing database to which I want to add a mileage app. Ideally what I would like is for employees to simply select a Start and Ending Destination (a list populated from a table called tblSites), indicate whether they returned to their starting location afterwards and then have miles automatically filled in from a table. But I want them to be able to manually enter mileage in case their start or end points are not on my table. I don't really have the slightest clue how to accomplish this. Which usually means it requires VBA which I know little to nothing about.

Thank you.

[Robeen]

The VBA may only be minimal, but I'm not sure you've given enough info for that to be determined.
One thing you could do is make it a requirement that all legitimate destinations be in tblSites.
Is that something you can do? It would certainly help standardize things for you.

If you MUST allow entries for destinations that are not in tblSites, then it still doesn't necessarily mean anything more than pretty simple VBA Code.
If your mileage is being entered into tblMileage [for example], you're going to have the Start & End points in there either way . . .
If the destinations are in tblSites - your mileage & destinations can be taken from there.
If not - the User will have to enter the destinations & the distance between the two sites.

Give us some more information so we can help more.