entering and modifying records already entered in a table without duplicating

[moe0303]

Hi, I am an extreme newbie to access. I would like to enter data into a table using a form. I have the table and the form built already, but it doesn't work like I want it to.

I am entering parts for inventory. The part number is the primary key. What I would like to happen is this: When inputing the part number, (maybe using a combo list) if the part has already been input have it go to that record so I can modify the quantity, if the part hasn't been input let it input it like a new record.

I have tried to make a combo box that is populated off of the table, but it wont let me add anything new. I also have no idea how to make it go that record so I can modify the other fields.

Thanks in advance for any help you can give on this.

 

[pl456]

You would be better creating a query based on the table then setting the forms record source to query you ave created.
You can then specify criteria in the query design to select and display the records you want.

 

[The_Doc_Man]

The forms wizard allows you to define a list box to automagically find a matching record, and I believe there is a "Not In List" even such that if you enter a number that is new to the list, you would know it and take separate action.

 

[moe0303]

Thanks for replying

Thank you both for your input. I used a combobox that uses the query as a source and that seems to have worked well except for one little quirk. When the item is a new one, I would like to just be able to hit tab then have it go to the new record so that I can input the new information. As it is now, if I hit tab, it just starts writing over the 1st record in the table. Here is a picture of the for that I have. The item number is the primary key. (I don't know if that matters)

 

[moe0303]

Is there a way to make the form go directly to a new entry when it opens?