Filtering Data or Unmatched Data (1 Viewer)

[sohailcdc]

I am totally new in Access VBA, plus I am trying to learn during my free time, I am able to create the following Unmatched query (using Wizard), but now I am trying to learn using VBA code

Table1
Curr CurrName
CAD Canadian Dollar
USD American Dollar
GBP British Pound
AUD Australian Dollar
EUR Euro

Table2
Year Curr
2013 CAD
2013 USD
2013 EUR
2014 USD
2014 GBP
2014 AUD

Now, what I am trying to Learn Filtering Data at Form Level
Combo Box - Select Year (I am able to Learn using VBA code- Working Perfectly)
ListBox1 - Show Currcode for selected year (I am able to learn using VBA code and working perfectly)
ListBox2 - Would like to see Unmatched currcode from Table One (unable to figure-it-out how this will work in VBA)

E.g.
ComboBox = 2013
ListBox1 = (CAD,USD,EUR)
ListBox2 = should show (GBP and AUD) - here I am totally blind Need your Help

Thanks in Advance

 

[Cronk]

Select table1.Curr FROM Table1 Where table1.Curr in (Select Curr from table2 where Year =2013)=False;

 

[sohailcdc]

Hi Cronk
Thanks for your reply
I typed the following syntax, but nothing is appearing in the list box
Dim sql1 As String
sql1 = "SELECT Table1.curr FROM Table1 WHERE table1.curr in(SELECT curr FROM table2 WHERE year=2013)=False;"
Me.List3.RowSource = sql1
Me.List3.Requery

 

[sohailcdc]

Thanks it resolve