Go to record through process of elimination

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

Guest

Is there any way by form, query or filter to select an option from a field
(preferably drop down) and then in the next field it only bring up options
for corresponding records?

E.g. 6 companies in 'Corp' field, all with different sub companies and
divisions. If one of the 6 from corp selected, can the next field just show
the relevent sub companies to the slected corp option? With Sub selected can
it then only show the relevent divisions to the chosen field?

I have tried single and multiple table to no avail, any assistance is
greatly appreciated.
 
Hi Brinyat,

Have your combo box set up so that when you select a company, it requeries
the sub-company combo box. The sub-company combo box needs to have a query
setup similar to this:

Select ID, SubCompany from tblSubCompany where [CompanyID] =
iif(isnull(forms!FORMNAME.cboCompanyID), [CompanyID],
forms!FORMNAME.cboCompanyID)

Which will cause the sub-company combo to only display those relevant to the
selected company.

You would call the requery in the after update or on click event of the
Company combo, like this : me.cboSubCompanyID.requery

Hope that helps.

Damian.
 
Back
Top