Opening a record

  • Thread starter Thread starter Rush
  • Start date Start date
R

Rush

I have an access form where i enter an id number, then
click on a button to take me to a second form. I would
like for the information corresponding to this id number
to pop up in the second form automatically when the second
form comes up. problem is, when i click on the button and
the id number is not already in the database, then the
information for the first record in the database comes up.
in this case, i would like for the new id number to be
there with a blank form. How would I accomplish this?
Thanks in advance
 
Try using DCount() to see if the ID entered exists in the
Table or not. If it does, open the second Form at this
Record. If it does, open the second Form at new Record.

HTH
Van T. Dinh
MVP (Access)
 
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

Access Automatically Send a notification email once a record is added 0
Pop-up form that creates record that links 1:1 to main form 0
Create New Entry From Exisiting Data 8
new record in new form 1
Finding a record through a form 8
Identify and display duplicate records 0
Linking records to auto complete information 1
Data Entry Form and Auto Number ID 2

Back
Top