strSQL with WHERE

[edojanssen]

I want to select a department in the form and then the field Text1 must be filled with data from tblFaktRegHerinnering filtered on the chosen department. I tried to filter with WHERE but then I get the error "to few parameters: expected 1". Without WHERE I get all data from tblFaktRegHerinnering.

Who knows a way to filter the data to be shown in field Text1.

 

[MStef]

Hello Meyer!

Here it is.
I have changed List Box in Combo Box.
Open "frmEmailReportCopy"
Try with 118 first, then 110.
Look at VBA, Module.
I think it is what you want.

 

[edojanssen]

Hi MStef,

You're on the right track. We're almost there now. When now I select another department the data of the new department and of the previous dept is shown. What I would like when I select another dept is that only the data of the chosen dept is shown.

Thanks for helping me out.
Edo

 

[MStef]

Private Sub lstMailTo_Click()
With Me!lstMailTo
Me!txtSelected = .Column(1)
Me!txtAfdeling = .Column(0)
End With

Make a change in lower line

Me.Text1 = fConList
End Sub

 

[edojanssen]

Hi MStef,

It's working. Thank you very much. You've made my day.

Edo