Problem with two Continuous Forms on one table


Peter Stone

Access 2003

I have a table of geographical locations E.g., Oceans (Pacific, Atlantic,
etc.), Continents (Asia, Africa, etc.), Countries, etc.

I select a location in a combo and connect it to other locations with a self
join in a junction table using a combo on a continuous form.

To simplify the process I want to have several continuous forms.

At the moment, one continuous form combo selects continents (qryCont).
Another selects Oceans (qryOcean)

Problem: Once I have made a selection on fsubCont.cboCont,
fsubOcean.cboOcean displays a second combo with the first one blank.

Any way around this?

Thank you



Peter Stone

I worked it out myself.

To have multiple continuous sub forms on the same table they must be on
separate queries NOT on the Table.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question