Create an add/edit form in access 2007

[Abdulqadir Aziz]

Hi, I want to create an inventory on access. I want to create a form that can either add a new item or edit an existing item in a table. If I place a barcode in the barcode textbox in the form, I would like all the other textboxes to show the corresponding product information for quick editing. If not, I want all textboxes to remain blank, and a new entry to be added to the table. How might I go about doing this?

[NeoPa]

That's a risky idea if, as it sounds, you want the BarCode TextBox to be a bound control of your form. How would the operator use it both to select a new item as well as update an existing one (which is after all the natural expectation of a user in those circumstances)?

What is a sensible approach is to create a separate, unbound TextBox (possibly in the Header section of the form) which is used specifically for selecting the record to navigate to. In such a case you would need to make sure you handled the possibility that the user navigated away from the current record without saving any existing changes.

Basically though, in the AfterUpdate event procedure of this new TextBox (we'll call txtBCNav for now) you would have some code to navigate to the correct record, or go to the new record if no matching one were found, and ensure the BarCode TextBox had the value already defaulted to the value from txtBCNav (Only required for New records of course).

[jimatqsi]

"I want to create an inventory on access. I want to create a form that can either add a new item or edit an existing item in a table"

Have you designed the database already? There is a new form wizard to help get you started. Your question is a bit broad for a forum such as this. Study the examples in the sample database that came with your Access installation.