G
Guest
I have a form, BatchCoversheet, which prompts for a [BatchNumber] in the
criteria of the query it’s based on. I would like for another prompt to come
up if the Batch Number entered doesn’t exists and ask the user if they would
like to add a new Batch Cover Sheet. When they select yes I would like the
Batch Number that they entered to automatically be populated. If they select
no, I would like the original prompt for [BatchNumber] to come back up. I'm
not sure if all this is possible, but any help on this question would be
helpful. Thank you in advance!
criteria of the query it’s based on. I would like for another prompt to come
up if the Batch Number entered doesn’t exists and ask the user if they would
like to add a new Batch Cover Sheet. When they select yes I would like the
Batch Number that they entered to automatically be populated. If they select
no, I would like the original prompt for [BatchNumber] to come back up. I'm
not sure if all this is possible, but any help on this question would be
helpful. Thank you in advance!