Another beginners question if I may. Let's say I have a database with several jobs in it. The main form shows the data for a particular job whose name is given in a list box (which is bound to a "lookup table" containing job names with each jobname's primary key represented by a foreign key in the main table, because the record source for the main form is a query limited by the foreign key of that job.). The user will be working with this set of data for some time. What's the proper way to compel the job name in the list box to persist across sessions? Store it on closing the database in a 1-record table? If so, how do I load that combo before the form's recordsource needs to fire.
thanks, Ron