On a form with an ADD record button. Once clicked the button commands an assocaited listbox to pull in data. That listbox has defult lookupdb that pulls in the first of a record in a number column from an associated table. This dblookup works fine, my problem though, is that it pulls in the first record. I need it to pull in the LAST record, plus 1. For example, once I hit the add button, the listbox shows 1. I need it to show the last number of 10 plus 1 (so that would be 11). How do i do this?
I’ve tried using a descending query, and I’ve tried using the acLast+1 in many different parts of the
