Searching and Adding records from a Form.

[RivaCom]

It's been a long time since I went over this, 3 years ago I probably
could of whipped this out no problem. I am working IT for a company,
and they wish to do a Inventory for all their Tech hardware. So I put
together a nice set of tables to be used. Now I'm hoping to make this
as easy as possible, so I decided to throw together a few forms. My
problem is, I can't seem to remeber how to do either(add or search).
Basicly what I have is a Main menu form, which has Search Inventory or
Add Inventory. For search, I want them to be able to type in a number
and have it pull up the matching record either in the form or in
another form I suppose. For the add inventory, I have all the fields
of the main inventory table setup, I just need a way to figure out how
to add all those fields to the inventory table with a click of a
button. Any help would be great, im just trying to make this process
as easy as possible.

 

[Allen Browne]

Hmm. Big question covering lots of issues.

There are several search options available when you use any bound in Access,
e.g.:
- Filter by Selection (Toolbar button, or right-click)
- Filter by Form (Toolbar button)
- Find (binocular icon on toobar), with options for a specific field and
wildcards.

To find a specific record in a form with code, use FindFirst on the form's
RecordsetClone. Here's an example:
http://allenbrowne.com/ser-03.html

To open another form filtered to a specific record, use OpenForm with the
WhereCondition. The basic approach is explained here:
http://allenbrowne.com/casu-15.html

For a more comprehensive example, searching on several fields, see:
http://allenbrowne.com/ser-62.html

To append specific values as a record to a table, execute an Append query.
Two approaches compared here:
http://allenbrowne.com/ser-60.html

Hope that jogs the memory for you.