title: Combo Box Filter Based on Value in Hidden Form
body: <p>After a successful logon information about the user is held in a always open but hidden form.</p>
  
  <p>Within the program there are various dropdowns that I want to filter based on 'txt_security' from the hidden form.</p>
  
  <p>Row Source Example</p>
  
  <pre><code>SELECT tbl_master_ship.master_ship_id, tbl_master_ship.admin_only
  FROM tbl_master_ship;
  </code></pre>
  
  <p>Example of data is there are 5 total ships, only one is admin_only.  If txt_security = 1 then show all 5 ships else hide the one record marked admin_only.</p>
  
  <p>I tried this but it only shows the one record if txt_security = 1.</p>
  
  <pre><code>WHERE (((tbl_master_ship.admin_only)=IIf([forms]![frm_global_variables]![txt_security]=0,True,False)))
  </code></pre>