Query to create new file

  • Thread starter Thread starter mrrherrera
  • Start date Start date
M

mrrherrera

I want to create a query that will search the database table for a specific
case number. If it doesn't find the number, then it should open a new form
to input the new case. If does find it, then it would open the form with
that specific case. How do I go about doing this?
 
I want to create a query that will search the database table for a
specific case number. If it doesn't find the number, then it should
open a new form to input the new case. If does find it, then it would
open the form with that specific case. How do I go about doing this?
Click to expand...

Just open your form with a WHERE clause that specifies the case number.
The default behavior for such a filter that has no match is to display
the new record position.

DoCmd.OpenForm "FormName",,,,"CaseNumber = 12345"
 
You must log in or register to reply here.

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

Command button to open folder 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Get a number from a table to a form. 0
problem with criteria in query 3
Create New Entry From Exisiting Data 8
Create a new record in a tbl using another record from a diff tbl 3
Monthly Inspection Database 0
Unable to create MDE File 3

Back
Top