At work I have a form that we enter data from access into, and then fax out. I have to base any code I do off of the form itself, so I cannot create the form from access.

What I want to do is have a form open at the launch of the file, with a combo box to choose the hospital state and one for the hospital name. The hopsital name is under seperate tables, each state has a table for its hospitals. I have already created the form itself,...