Promt to add a new record if the value doesnt exist

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Attn Sprinks -need help on second half -Batch part 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Checking if record already exist 4
COMMAND BUTTON OPEN FORM 4
Attn Sprinks - clarification on VB code 6
Query a Yet To be Named Table? 4
Lookup and/or create new record from same box? 6
Search and populate or add new record 2

Top