B
BobbyOH
I've checked all the newsgroups and tried all the suggestions but find I'm
still not able to make my form do what I want.
We are a non-profit referral agency. We have people registered as Applicants
(tblApplicants). Some Applicants can be Plumbers, Carpenters, Handymen etc
(tblCategories). When a customer calls for the name of a Carpenter, I enter
the data in a Job Detail table.
I want to be able to select a category like Carpenter, have it fill the list
box and then select 3 or 4 names that can do the job. I will then go back in
a week or so when I find out who did the job and enter the Selected info in
a subform.
I have an unbound Category combo box (cbxCombo1 - Row Source Type:
TBL/Query - Row Source: tblCategories). When I select a category, it very
nicely fills an unbound list box (lstSelectReferred - Row Source Type:
TBL/Query - Row Source: SELECT [Name], [Phone], [CurrentAge], [Town],
[Notes] FROM qryApplicantsByCategory WHERE
[CategoryID]=Forms!frmJobDetail!cbxCombo1; )
My problem is that I can select multiple names in the list box but it stays
the same for each Job Detail record. I know I need to reference the Job
Detail ID somehow but can't figure out how to do it.
Maybe I'm on the wrong track. I do have it working with two subforms but I
am trying to make the data entry as simple as possible as I'm trying to
teach someone who has never used a computer before.
Thanks...
still not able to make my form do what I want.
We are a non-profit referral agency. We have people registered as Applicants
(tblApplicants). Some Applicants can be Plumbers, Carpenters, Handymen etc
(tblCategories). When a customer calls for the name of a Carpenter, I enter
the data in a Job Detail table.
I want to be able to select a category like Carpenter, have it fill the list
box and then select 3 or 4 names that can do the job. I will then go back in
a week or so when I find out who did the job and enter the Selected info in
a subform.
I have an unbound Category combo box (cbxCombo1 - Row Source Type:
TBL/Query - Row Source: tblCategories). When I select a category, it very
nicely fills an unbound list box (lstSelectReferred - Row Source Type:
TBL/Query - Row Source: SELECT [Name], [Phone], [CurrentAge], [Town],
[Notes] FROM qryApplicantsByCategory WHERE
[CategoryID]=Forms!frmJobDetail!cbxCombo1; )
My problem is that I can select multiple names in the list box but it stays
the same for each Job Detail record. I know I need to reference the Job
Detail ID somehow but can't figure out how to do it.
Maybe I'm on the wrong track. I do have it working with two subforms but I
am trying to make the data entry as simple as possible as I'm trying to
teach someone who has never used a computer before.
Thanks...