Preventing Browser Refresh from Incrementing Counter

[smokin_joe]

I am looking for a technique to prevent adding the same record to the database
as result of the user 'refreshing' the browser.

Presently on entry to the page i perform the update/insert to the datatbase
(ACCESS) and then use a query:

Select MAX(customerID) AS HighCust From customers

To display the last number (MAX) to display the 'confirmation' number.

The problem is, if the user refreshes the browser the app ADDs the record
again and assigns the next number.... is there a technique that anyone has used
that could prevent that from happening?

[Stressed_Simon]

Once the database insert has been completed then use cflocation to move to a new page. Then if the user refreshes the page it will only reload the new page and not the action page that did the upload!