Sorry but I have got stuck on the simple things. Don't want to use
auto number. I have a REF Field starting at 101. I want to increment
this by 1 every time I enter a new record, thanks

You can do so using VBA code to get the next number and assigning that number
to the field

The simplest way is to use an expression like the following. I would normally
use that expression in the before update event of form.
Me.txtRefControl = DMAX("REF","NameOFTable") + 1

The problem here is that in a multi-user environment it would be possible for
two users to get the same number depending on timing.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

On 12/8/2010 7:33 AM, Paul wrote: