Hi John
Simple question really but complicated answer.
You could use a master detail form for such a thing look at
http://office.microsoft.com/en-gb/assistance/CH011097241033.aspx
For a full explanation and How to. You would have two buttons on the form
one for new record and one to search for the old one. You could then amend
all details and save and job done.
Do your research on Master/Detail first as it helps to get a good grip of
this.
Cheers Adam
"johnshansen[ at ]gmail.com" wrote:
[Quoted Text] > I am new to infopath and am creating a form that is connected to an
> access database. I would like my form to be able to autopopulate
> certain data groups (when possible), but also let me change and add to
> those data groups.
> As I type an old value into customer name, I want it to bring up
> company, address, phone number etc. However, at the same time, I would
> like to be able to add new information in for new customers, so that if
> the customer name is new, I can type all of this information in to
> these fields(and store the information in the database).
> Is this possible, and if so how would I go about doing this?
>
>
|