<div>
is the form bound to the table or query?<br />
what does Me!txtRecord contain? is this an input from the keyboard?
</div>


is the form bound to the table or query?
what does Me!txtRecord contain? is this an input from the keyboard?

<div>
Hi Capricorn1<br />
<br />
Yes it's a bound form. Me!txtrecord is an unbound text box where the record number is entered from the keyboard. <br />
<br />
ID is an autonumber field of the bound form.<br />
<br />
If the specific record number doesn't exist (it's been deleted for example, or the record number being looked for is greater than exists) a message box will appear notifying the user the record doesn't exist.<br />
<br />
Thanks,<br />
George
</div>


Hi Capricorn1

Yes it's a bound form. Me!txtrecord is an unbound text box where the record number is entered from the keyboard.

ID is an autonumber field of the bound form.

If the specific record number doesn't exist (it's been deleted for example, or the record number being looked for is greater than exists) a message box will appear notifying the user the record doesn't exist.

Thanks,
George

<div>
Thanks again Cap. Worked perfectly!<br />
<br />
George
</div>


Thanks again Cap. Worked perfectly!

George

<div>
<div class="content wysiwyg-content">
I am using the findrecord function and I need to have a message popup if the record isn't found. <br />
<br />
The code I am using is:<br />
<br />
DoCmd.GoToControl &quot;ID&quot;<br />
DoCmd.FindRecord Me!txtRecord, , True, , True
</div>
</div>


I am using the findrecord function and I need to have a message popup if the record isn't found. 

The code I am using is:

DoCmd.GoToControl "ID"
DoCmd.FindRecord Me!txtRecord, , True, , True

Findrecord message if no record found

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.