Autonumber incrementing after updating fields?

[gdev]

Hi Everyone,

How I can make an autonumber increment after
dlookup does it thing to make sure there isn't a record matching the new entries?

As soon as I select the plan, autonumber increments which makes the if statement always true. I don't want autonumber to increment until after dlookup checks for matching records.

Or is there a better way to do this?

If (Not IsNull(DLookup("[CostCenterid]", "tCostCenter", "[costcentercode] ='" & [costcentercode] & "'" & "And [costCenterRegion] = '" & [costCenterRegion] & "'" & "And [planid] = " & [planId]))) Then
MsgBox "stop", vbOKOnly
Me.BusinessContactName.Enabled = False
Me.ControllingContactName.Enabled = False
Me.costCenterType = False
Else
Me.BusinessContactName.Enabled = True
Me.ControllingContactName.Enabled = True
Me.costCenterType.Enabled = True
End If

Thanks
Gwen

 

[willir]

Hi Gwen

The autonumber is assigned / created with the OnInsert event -- as soon as Access "sees" any entry for a bound control (a control field on the form that is linked to the source table or query), it creates the number.

The work around would be to do your testing with an unbound control field. Then determine to proceed or not.

For example, use an unbound combo box to select "the plan"

Having said that, you may wish to review...
Why AutoNumber shouldn't be used in MultiUser databases (And How to ge the Unique Number) faq700-184

Richard

 

[TheAceMan1]

How are ya gdev . . . . .

[blue]Willir[/blue] is correct. No matter how you do it, you have to write to the new record ([purple]put the record in edit mode . . .[/purple] depicted by the pencil icon). Write to a control thru VBA.

See Ya! . . . . . .