Msgbos Question

[Slides_Library]

I want to have a msgbox tell the user if an [accnum] field is blank. But I also want it to say what should be there.

Code:
If IsNull (Me.Accnum_2)=False Then Msgbox "Accession Number [Value of accnum field here] has not been entered in Accession Number Form"

I was thinking I could have it fill in for each record missing don't know if it is possible

Thanks
Slides_Library

 

[pbaldy]

Generally:

Msgbox "Accession Number " & [Value of accnum field here] & " has not been..."

 

[Slides_Library]

Thanks for the repley I should of known it would be that easy.

Slides

 

[boblarson]

Just a quick question about this too. It sounds like you are storing redundant data because why would you tell the user to enter a number when you already have it somewhere else?

 

[KeithG]

I think maybe the number is the PK but if you already know what the value should be why not just fill it in automatically instead of prompting the user.