Continous Sub-Forms and combo boxes

M

Mary

Here is my problem.I have a sub-form that has two combo boxes one is Project
the other is ActType. I want to be able to select a Project from cboProject
and then have it populate the ActType combo box. The sub-form is a continous
form so when I select the Project is does populate the ActType correctly but
when I leave the form and come back in nothing shows in the ActType combo
box. It is maintained in the back end of the database.

Here is part of my problem I think. Eact ActType is associated with either
one or many Project Types. While each Project Types is associated with
certain Projects.

My tables consist of these in my database:
tbl_ProjectMaster (has a reference to the tbl_ProjectType)
tbl_ActType
tbl_ProjectType
tbl_junction (which associates the tbl_ActType to the tbl_ProjectType)

Please help. This database is used to record time spent on certain projects
and certain activities.
 

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

Similar Threads

Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
realtionships - 3 different tables to be related on seperate table 2
filtering a form based on the values of a subform 0
Combo Box based on another Combo Box 1
Combo Boxes and Sub forms 1
Subform combo boxes 3
Combo box not populating subform 1

Top