unbound criteria to refresh list

[jepoysaipan]

Hi guys,

I have a form with the following controls:

Control Name: cboEmpName
Source: Employee

Control Name: cboCustomer
Source: Customer

Control Name: cboJobOrderNo
Source: JobOrder

Control Name: lstRecordShow
Source: Employee

Now the problem, I wanted to only show on the listbox(lstRecordShow) the records depending on the user choices, it can only be sorted based on one criteria or it can be a combination of the three combo boxes.

I've searched the forum and only shows to open reports not to update a control within a form.

Please help me with this one, Thanks in advance.

Jeff

 

[pbaldy]

What you want is basically the same concept as "cascading" combo boxes. If you search on that, you should find methods you can adapt to your situation.

 

[Zaeed]

what you want to do is modify the rowsource of the control based on the selections of the combo boxes

 

[jepoysaipan]

Hi guys,

I've searched the cascading form but didn't get the result I wanted to happen, I tried changing the row source bu no luck, can someone give me a working example based on the info I provided.

I really appreciate all your input.

Thanks