I am writing the exact query I have put into access, pardon me for any confusion. This query works fine but the listbox has no heading, I want the list box to have exact same heading as field name in the table.
Me.List_All_Wells.RowSource = "SELECT Permits.[Operator Name] as OPERATOR, Permits.[Well No] as [WELL No],Permits.[API NO] as [API NO],Permits.[Total Depth] as [TOTAL DEPTH] FROM Permits WHERE(Permits.County) = '" & Me.Combo_county & "' and permits.[Operator Name]= '" & Me.combo_operator & "'"