This is probably one of those that I should know off the top of my head-
I have a table whose PK is an autonum that just counts up. I need to be able to set a variable to the highest number in this field. I’ve tried several different ways, but keep 
.
I’ve written a make-table query to keep a one-record, one-row table up to date, bit can’t figure out how to set a variable equal to it.
TMI Warning==> AND in case I’m just going about this ALL WRONG, here’s what I’m trying to accomplish: I have a form that lists item numbers based on a selection from a combobox. I’m adding functionality to add another choice to the combobox. Accomplished that without problems. But I want the form to automatically show the items from the newly created choice. (Yes, it will be blank, but that’s OK).
