Editing records through a form

J

Jenny

I have a table with 1000 items containing information like item name, cost,
supplier. I would like to be able to edit these items through a form. How
do I allow the user to perform a search on the 1000 items and then select the
one that the user wants to edit? That is my problem. I don't know how to
allow the user to select the item that he/she wants to edit.

Is anyone able to do this using queries and macro? I'm not Access code
orrientated.
 
L

Larry Linson

Jenny said:
I have a table with 1000 items containing information like item name, cost,
supplier. I would like to be able to edit these items through a form.
How
do I allow the user to perform a search on the 1000 items and then select
the
one that the user wants to edit? That is my problem. I don't know how to
allow the user to select the item that he/she wants to edit.

Is anyone able to do this using queries and macro? I'm not Access code
orrientated.
Click to expand...

If there is a Field in the Table that the user can employ to identify the
Record, then the Combo Box wizard will generate code so the user can specify
a value, and then it will populate your Form with the Record, or Records,
that match (if any). There'll be code, or macros, generated by the Wizard,
but you won't have to write any.

Larry Linson
Microsoft Access MVP
 
P

Pat Hartman \(MVP\)

Access forms come with a great search feature built right in. It is called
filter by form. Select the filter by form icon from the toolbar - between
the A-Z/Z-A buttons and the binoculars are three filter buttons. Filter by
form is the middle one. Or, you can get to it via Records/Filter/Filter by
form.
 
Top