Hi OneZero,

You may wish to look at Excel's built in Data Form:

Data | Form.

You may also wish to look at John Walkenbach's Enhanced Data Form, which is
more flexible and which, for a relatively nominal payment, provides access
to the source code:

http://j-walk.com/ss/dataform/index.htm


---
Regards,
Norman



"onezero" wrote in message
...
i am building up an inventory system as a project.

the system has a master database whereby the user can either add in new
items or delete existing items using a user-interface. the user should be
able to search for the an item under either the category that it belongs
to
or by keywords on the interface too.

currently, i am stuck at the parts on deleting existing items from
database
on the user-interface and searching by keywords for the items. Could
anyone
pls give some advise on how to do them?