Search results

Yes! It's numeric and it represents months from 1 to 12

-- For cboFilterTeam (The source is a Query) SELECT [rsel_teamElementary].[teamName] FROM rsel_teamElementary ORDER BY [teamName]; -- For cboFilterPeriod (Typed manually) 1;2;3;4;5;6;7;8;9;10;11;12

Yes it's what I did .. Thank you It opens the other form with the listbox but it doesn't filter data here is the code as you suggested : Private Sub cmdApply_Click() Dim var As Variant Dim strTeam As String Dim strMonth As String Dim strFilter As String Dim strSQL As String Const...

This is the excat source of the listbox

Thank you CJ any way. Thank you @Arnelgp for your help bu i'm getting this error : just for this part of code :

Hi arnelgp, For the listbox, it's already linked to a table. And when opened, it shows the values not filtered. For the combobox, the values are from a query and i want to show the listbox in the other form based on the combobox selection. Many thanks

Hi CJ I tired this code but i didn't work Private Sub cmdApply_Click() DoCmd.OpenForm stDocName, , , lbo_actuals.RowSource = " SELECT * FROM tbl_temp WHERE teamName=" & Forms!frm_filterActuals!cboteamFilter & " AND actualMonth=" & frm_filterActuals!cboFilterPeriod End Sub

Hello all, I'm trying to open a form (frm_viewActuals) that contains a listbox (lbo_actuals) base on a two comboboxes (cbo_teamName & cbo_period) values in another form called (frm_filterActuals). What i'd like to do is to update the listbox in frm_viewActuals after clicking "Apply" button in...