ACCESS 2010 SQL No data returned. SQL Returns data same query
<p>I have the same SQL query in Access and I checked it out in SQL Server and coming up with two different results.  In access I am getting 0 records sent back (Recordcount = 1) but nothing shows.  In SQL I get about 30 records.  Not sure what is going on.</p>

<pre><code>Dim sql as String
Dim rs As Recordset
sql = "SELECT * FROM Client Where State = 'MN'"
Set rs = CurrentDb.OpenRecordset(sql, dbOpenDynaset, dbSeeChanges)
'Being called from frmClient
DoCmd.OpenForm "frmUpdate2", acNormal
</code></pre>

<p>The text fields on frmUpdate2 are coming up blank.<br>
Control Source is correct and matches</p>

<pre><code>Filter Lookup = Database Default
Enabled = Yes
</code></pre>

<p>frmUpdate2:</p>

<pre><code>Record Source = Client
Recordset Type = Dynaset
Allow Additions = Yes
</code></pre>