Primary Key and form

[GraemeG]

Hi,

I have a (pre record selector) form with one text box to enter a primary key to then open the main form to the specific record.
using

[CODE][Private Sub CmdSearch_Click()
DoCmd.OpenForm "Internal Survey Form", , , "Propref = '" & Me.txtPropref & "'"
End Sub/CODE]

It still opens to a blank form if there is no record matching.


How can I prevent the main form opening and have a message saying no record found?

Thanks
Graeme

[TheShabz]

Some logic/pseudocode. prior to opening the form, open a recordset (rst) with the same criteria. if rst.bof AND rst.eof THEN msgbox "empty" ELSE OpenForm.

Basically, you're checking to see if the first entry of the recordset is both the begining and the end of the recordset. If true, then it's empty and you can throw and error msg.

[RuralGuy]

Add a DLookup() first in your code and only execute the OpenForm if the key is found. DLookup() usage examples: http://access.mvps.org/access/general/gen0018.htm