Results 1 to 2 of 2
  1. #1
    kmiszczak is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2011
    Posts
    1

    need a If /then statement


    Just a beginner here so be gentle I have created .mdb to track inventory. Where I am having an issue is duplicate records. I want to be able to re-add a record without deleting the old record however I do not want duplicate records so I am looking to create a if/then statement or a After event that will let me add a new record. So if the inventory has been received I would like that record to be considered as complete so that if I need to order more the form will not see it as a duplicate (i.e. part # 12345 has a demand of 500pcs we received 500 pcs now need more) How would I go about creating a scenario that would allow for the addition of the same part once it has met the criteria of being received?

  2. #2
    KathyL is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    94
    Quote Originally Posted by kmiszczak View Post
    Just a beginner here so be gentle I have created .mdb to track inventory. Where I am having an issue is duplicate records. I want to be able to re-add a record without deleting the old record however I do not want duplicate records so I am looking to create a if/then statement or a After event that will let me add a new record. So if the inventory has been received I would like that record to be considered as complete so that if I need to order more the form will not see it as a duplicate (i.e. part # 12345 has a demand of 500pcs we received 500 pcs now need more) How would I go about creating a scenario that would allow for the addition of the same part once it has met the criteria of being received?
    Set up an index or primary key on the table, and set it to no duplicates.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. iff Statement
    By tkandy in forum Access
    Replies: 0
    Last Post: 03-20-2011, 02:31 PM
  2. if statement
    By sirlosi in forum Queries
    Replies: 4
    Last Post: 03-07-2011, 11:26 AM
  3. Help with IF statement
    By mkallover in forum Programming
    Replies: 7
    Last Post: 01-04-2011, 04:47 PM
  4. IIf Statement
    By dref in forum Forms
    Replies: 2
    Last Post: 07-16-2010, 02:46 AM
  5. IIf Statement...HELP!
    By bdhFS in forum Queries
    Replies: 5
    Last Post: 05-19-2010, 07:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums