Auto filling a form

[Don Rountree]

Two questions - Can this be done? If so, how do I get
started?

I want to fill a form automatically if the required
information is in the database. If the required
information is not in the database, I want to be able to
type it into the form.

I have a search form that displays all records in an item
database. There are multiple fields in the record. I
have a separate form that is not bound to the items table,
but has the same fields. If what I'm looking for is in
the item table, I want to be able to populate the fields
in the unbound form. If not, I'd like to be able to type
the info in manually.

I could bind the unbound form to the items table, but then
I could not manually enter information without getting an
error telling me a record could not be found in the items
table.

Any help would be appreciated.

Don Rountree