So far I've tried a couple methods including setting default value to "=AssignRMA()" Where that function is:
Code:
Public Function AssignRMA()
AssignRMA = CurrentDb.OpenRecordset("qryMaxRMA").Fields("Max")
End Function
^ This method only returns a #Name? error in that field.
I also tried creating a query that successfully returns a single value equal to the Maximum existing RMA number plus one, and setting Default Value for field on form to =DLookUp("Max","qryMaxRMA").
I will mention, as I am typing this, I set it back to =DLookUp("Max","qryMaxRMA") method so I could properly copy the expression into this thread and... it worked this time. Likely I didn't use quotations on the field the first time I tried.