Adding increment to a number field in a form.

[isladogs]

@Ridders (to clarify to whom)Naw, I don't think so. If property number requires brackets (and I agree it does), then so does Property Information. Seeing as how you have the tables and such, see if a second set of brackets fixes the problem.

@Micron


As previously noted by June in post 9, it works without [] around the table name! Very odd but true!
Of course, it also works with the table name enclosed in []
I had previously tested both in the Immediate window, but not in a form

[Micron]

Then what's causing the error message??

[isladogs]

The fact that originally there was no [] around the field name which does require them.
Why it should be different, I've no idea

For interest, I also rechecked this, deliberately using a space in the appallingly named [Field Name]:

DLookup("[Field Name]", "Property Information", "[Property Number] = 2")

That works only if the 2 sets of [] shown are included - once again the domain (table name) doesn't need them

[Micron]

OK, I had to go back to your post 13 (I think). I mis-read and thought you were saying with brackets around both names that it was still failing.
Switching from coffee to beer now as coffee obviously isn't helping.
If that doesn't cure me, there is always Scotch in the cabinet.