Q
Querent
i've been combing this forum for assistance since i started this project, and
i've learned much (thank you all) but can't seem to figure this one out:
i have just altered two combo boxes on my service call entry form to allow
for the selection in "Customer" (company name) to filter the names available
for selection in "Contact". This works, so far as listing only the names of
contacts at, say, Fools Inc., and nobody else in the database (for example,
nobody from XYZ Tech or WhoVac)
The problems i have now discovered are:
1) Contacts available need to be refreshed manually if i change the
Customer selected (this is minor; probably some event code needs to be
added), and
2) No matter which name is selected, the box insists on displaying the
first one in the list! For example, i've just got off the phone with April
Fool from Fools Inc. about her boss' machinery, and i start filling out a
claim. i select Fools Inc. on my Customer combo box drop-down, no problem.
i pull the Contacts list down and see John Q. Fool, April Fool, and Phineas
P. Fool -- no problem.
i select April, and click, and when i release the mouse pointer, there is
John Q. Fool in the selection box. (And if i want to force it to display
April or Phineas, i have to open the Table itself and choose her from the
dropdown box in the Contact Field -- which according to the wisdom that i
have gained here is a big no-no)
What am i staring right at and not seeing here? Many thanks for your
collective guidance!
Querent
i've learned much (thank you all) but can't seem to figure this one out:
i have just altered two combo boxes on my service call entry form to allow
for the selection in "Customer" (company name) to filter the names available
for selection in "Contact". This works, so far as listing only the names of
contacts at, say, Fools Inc., and nobody else in the database (for example,
nobody from XYZ Tech or WhoVac)
The problems i have now discovered are:
1) Contacts available need to be refreshed manually if i change the
Customer selected (this is minor; probably some event code needs to be
added), and
2) No matter which name is selected, the box insists on displaying the
first one in the list! For example, i've just got off the phone with April
Fool from Fools Inc. about her boss' machinery, and i start filling out a
claim. i select Fools Inc. on my Customer combo box drop-down, no problem.
i pull the Contacts list down and see John Q. Fool, April Fool, and Phineas
P. Fool -- no problem.
i select April, and click, and when i release the mouse pointer, there is
John Q. Fool in the selection box. (And if i want to force it to display
April or Phineas, i have to open the Table itself and choose her from the
dropdown box in the Contact Field -- which according to the wisdom that i
have gained here is a big no-no)
What am i staring right at and not seeing here? Many thanks for your
collective guidance!
Querent