Need some help with a No Records Found query

[kilosierra71]

I've got a Form/Query set up where the user clicks a button and enters search criteria - in this case its a Phone Number - to confirm if the record already exists.



If the record exists, the user is done and they move on - end of story.

However, if no records are found with the Phone Number query I'd like for the user to be prompted with a pop up box or button or something asking them if they'd like to create a new entry.

Currently, the way new customer info gets entered into the database is with a bound form (for the sake of this post lets call it the 'New Customer' form). Ideally, this form works fine and people are comfortable using it so I'm not looking to change or alter the New Customer form or its processes.

I would like a way for this New Customer form to be prompted ("No Phone Number found, would you like to create a new entry?") when a Phone Number query returns no records.

I'm not an Access whiz so simple is better. Thanks and apologies for the extendo post!

[TheShabz]

I would do something to the effect of:

'This goes in whatever event you have once the user enters the phone number

If DCount("PhoneNum", "tblCustomers", "PhoneNum = " & Me.phoneControlName) > 0 Then
MsgBox "This phone number exists. Press OK to continue." , vbOkOnly
Exit Sub
Else
If (MsgBox "This phone number does not exist. Enter new customer?", vbYesNo) = VbYes Then
DoCmd.OpenForm "New Customer"
Else
Exit Sub
End If
End If

You should be able to follow long with what's happening there. DCount just counts up how many instances of the phone number there are.