<div>
Never would have thought of that, thank you.<br />
<br />
Sandra
</div>


Never would have thought of that, thank you.

Sandra

<div>
<div class="content wysiwyg-content">
I have a form that when teh user selects a name from the drop-down, I want the form to present the first record in the table that belongs to that user name. &nbsp;There would be multiple records with the user's name, but I want the form to present the first record. &nbsp;This is an ACCESS 2003 databse and needs to be written in VBA. &nbsp;I can get to the last record and the first in the recordset, but i want to go to the first for a particular user.
</div>
</div>


I have a form that when teh user selects a name from the drop-down, I want the form to present the first record in the table that belongs to that user name.  There would be multiple records with the user's name, but I want the form to present the first record.  This is an ACCESS 2003 databse and needs to be written in VBA.  I can get to the last record and the first in the recordset, but i want to go to the first for a particular user.

Go to first record int able with user name from drop-down

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.

Microsoft Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.