Forced comments if box is checked.

[mbenton]

Hello everyone, I've created a form based off one of my tables. One field is a "Reject" yes/no box. The other field is "Comments". I would like user not to be able to navigate to the next record if comments are not given for the checked reject box. On this same form I also have a macro that will execute a query to append these rejects to a table. However, prior to executing the macro I want comments to be present if the reject box is checked. Can anyone help with this? Or give me some examples forcing comments if other conditions are met? Thanks.

[pbaldy]

I'd convert the macro to VBA, where you can easily test the yes/no box and then the comments. With a 2007 macro I think you can use a condition, but I think it might be clunky. Later versions have If/Then logic.

[mbenton]

I prefer your approach. Currently the macro only executes an append query but I'm much rather combine the steps. I'm a beginner in VBA so I'll have to search for the coding, thanks.

[pbaldy]

No problem, post back if you get stuck.