Thanks for the response Nick.

>Jim, I would suggest you:
>
>1. Instead of local variables create and assign form properties.
>
>2. If appropriate, create lookup tables for your section, township and range (or if they already exist somewhere just use those fields. IMHO (if possible) it is better to select existing (say, defined in the lookup tables) values from the listbox or combobox rather then input them in textboxes. (But really it depends on your app, also if the range is a date range you may enter it manually, or use any Calendar OCX control)

That does seem like a much better approach. I'll work on that and see what I can do with it.

>3. Instead of SEEK you may use SQL select to cursor, something like

I'm using a SEEK because I just need to get them to the first record in that area. From that point they have to do a visual scan of the data. It's sort of the last resort search option ;)

>You may also use parameterized view where parameters will be your selected (or entered) values from listboxes, comboboxes or textboxes.

Could you explain a little more on parameterized views?

TIA,

Jim