Expression builder help? Another #name? problem

[hoodoo]

Hello.

Long story short, I am trying to set default value property to a field in a form to be the last/max CustomerID (which is autonumber) from a different table than the one the form is associated with.

So far I've tried many expressions, but they always end up showing #name? error. Currently I'm using "=DLast([tblCustomer]![CustomerID];[tblCustomer])"

I read that that error may appear due to taken alias or something, so I tried changing CustomerID to something else, but the error persists.

I have GoToRecord New macro set to the form when it opens. What is interesting, if I open the form and press "Refresh All" in the ribbon, it somehow shows what I need (the most recently added ID from table tblCustomers in the form's field "Customer ID").

Thanks already!

[pbaldy]

Not sure that works (never tried), but all arguments are strings, so try

=DLast("[CustomerID]";"[tblCustomer]")

I'd personally use DMax, though it may not matter.

[Micron]

What is the second tblCustomer for? "=DLast([tblCustomer]![CustomerID];[tblCustomer])"
If it's a control name, it probably can't be resolved because it's ambiguous plus you have the reference in the criteria part of the expression, but you don't want criteria. I don't get your syntax either. Should it not be "=DLast("tblCustomer", "CustomerID")?
As for any difference, I suppose none also, as long as we're talking autonumbers since even sort orders don't seem to affect which is last versus max.
Just a thought since you are using auto number to construct a record id: would there be a problem if two users were doing this at the same time and one of them cancelled? Probably would not affect your DLast result, but it would create gaps. Probably not an issue - just wondering if it was considered.

[hoodoo]

Not sure that works (never tried), but all arguments are strings, so try

=DLast("[CustomerID]";"[tblCustomer]")

I'd personally use DMax, though it may not matter.

Oh my god, man, I really don't understand wtf, but it worked! Thank You so much!!

[pbaldy]

Happy to help!