one combo box to populate another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with combo boxes and text boxes. cboJobType is from table
tblPanelJob, while all other objects are from tblPanelJobDetail. I have two
problems:

#1. I tried basing a form on a query that lists all of the needed fields. I
can get everything to populate but the cboJobType. It has a popup requesting
the JobID, which is a field in the PanelJob table... but one I don't need.
This is a project that someone else started, and they didn't have anything
bound and wondered why it wouldn't show in the subform when they clicked on
"Add Record" button. But, they had a SQL statement to populate the combo
boxes, and it worked fine. However, I think I need them bound. So I should
probably get *this* fixed first. Any ideas?

#2. The other issue I'm having is that I can't get the first combo box
(cboJobType) to populate another combo box (cboJobDetail). I know this has
been posted before, but what I was finding was when they are on the same
table. I'm thinking it makes a difference that these are not.

Any suggestions? Would be greatly appreciated.

Thanks!
Seren
 
I don't think you can open the same table twice in a single instance as that
is what would be required to do this. I would simply list one as VALID JOB
TYPEs and the other as JOB TYPE DESC and use a ValidJobTypeID number to
relate one to the other. This would eliminate your problem and work fine I
believe.
 
Back
Top