Zero return on delete query

[IannWard]

Hi All

I'm a newbie learning access. I have created a query to delete an entry in a field, when I enter a value that I know does not exist, it prompts me to delete '0' entries. Can I add a message box that informs me that the value does not exist in the table?



Many Thanks

[June7]

I am confused. If you know the value does not exist why are you using it?

What do you mean by 'delete an entry in a field'? Are you deleting a record or changing value in a field?

Show your code.

[IannWard]

I am confused. If you know the value does not exist why are you using it?

What do you mean by 'delete an entry in a field'? Are you deleting a record or changing value in a field?

Show your code.

For example, if a user record has already been deleted, and I try to delete them it tells me that there is no record to delete. This is obvious, I know, but just wondered why access doesn't just say 'record does not exist' or something.

[June7]

Doesn't "No record to delete" have the same meaning as "record does not exist"?

[IannWard]

Well of course it does. I guess I was thinking if there was a way to change the message to a custom message like in a validation rule for example.

[June7]

I would validate the input before allowing the delete action. Then can popup a MsgBox with whatever you want to say.

[IannWard]

That's kinda what I was thinking, unfortunately, I haven't quite got to grips with validation rules yet, they look a bit complicated to me. Any help would be grateful..

[June7]

One approach is to do a DLookup on the table.

If IsNull(DLookup("fieldname", "tablename", "fieldname=" & Me.tbxInput)) Then
MsgBox "No record"
Else
'code to delete record
End If