<div>
<div class="content wysiwyg-content">
Access 2003. &nbsp;Sntax for FindFirst. &nbsp;[Username] and [Password] are fields in the table tblLogin. &nbsp;<br />
struserName and strPassword are captured from the Form using strUserName = Me......<br />
<br />
The following syntax does not work. &nbsp;Can someone please correct it. &nbsp;Thanks.<br />
<br />
Set db = CurrentDb<br />
&nbsp; &nbsp; &nbsp; &nbsp; Set RS = db.OpenRecordset(&quot;tblLogin<wbr />&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; RS.FindFirst &quot;[Username] = &nbsp;'&quot; &amp;&nbsp;strUserName &amp;&nbsp;&quot;'&quot; &amp;&nbsp;&quot;[Password] = '&quot; &amp;&nbsp;strPassword &amp;&nbsp;&quot;'&quot;
</div>
</div>


Access 2003.  Sntax for FindFirst.  [Username] and [Password] are fields in the table tblLogin.  
struserName and strPassword are captured from the Form using strUserName = Me......

The following syntax does not work.  Can someone please correct it.  Thanks.

Set db = CurrentDb
        Set RS = db.OpenRecordset("tblLogin")
        RS.FindFirst "[Username] =  '" & strUserName & "'" & "[Password] = '" & strPassword & "'"

Access 2003.  Syntax for FindFirst

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.