Hi All,

I should start by thanking you for taking the time to address my inquiry, as
well as admitting that I have absolutely zero experience w/ programming in
Access. So, if you are kind enough to offer a code or expression to help me
out, please understand that I may need some serious assistance getting
through it.

That having been said, I have a question. I have a form - "Data Entry" -
that has 20+ fields. The database contains over 100 records. I have been
asked to update the database (which I did not originally design) to do the
following:

When the person entering information into a new record in the "Data Entry"
form enters information that has been previously entered, the form should
either:

1. Revert immediately back to the record containing the already submitted
information; or

2. Auto-Fill in all remaining fields in the new record.

My understanding is that I should use a combo box. However, I have only
been able to have the combo box select the field that it is referring to, but
not fill in any of the other fields.

Thank you,
Sean

Sean:

What constitutes ' information that has been previously entered'? Is it one
particular field? More than one? All fields?

I suspect, however, that your question may be indicative of a design flaw in
the database. I might be wrong but it does rather sound like there is a lot
of redundancy if there is the possibility of records being near duplicated.
The relational database model eliminates redundancy as far as possible by
means of related tables, each of which represents an entity type, e.g.
Customers, Orders, Order Details, Products. This ensures that each 'fact' is
stored only once and thus avoids inconsistencies arising from 'update
anomalies' which might otherwise occur.

If you can explain what the database is recording we can probably advise you
further, but while its possible to give an answer to your question once the
clarification sought in the first paragraph above is available, we could very
easily be giving you bad advice unwittingly.

Ken Sheridan
Stafford, England

"sheelen" wrote:

> Hi All,
>
> I should start by thanking you for taking the time to address my inquiry, as
> well as admitting that I have absolutely zero experience w/ programming in
> Access. So, if you are kind enough to offer a code or expression to help me
> out, please understand that I may need some serious assistance getting
> through it.
>
> That having been said, I have a question. I have a form - "Data Entry" -
> that has 20+ fields. The database contains over 100 records. I have been
> asked to update the database (which I did not originally design) to do the
> following:
>
> When the person entering information into a new record in the "Data Entry"
> form enters information that has been previously entered, the form should
> either:
>
> 1. Revert immediately back to the record containing the already submitted
> information; or
>
> 2. Auto-Fill in all remaining fields in the new record.
>
> My understanding is that I should use a combo box. However, I have only
> been able to have the combo box select the field that it is referring to, but
> not fill in any of the other fields.
>
> Thank you,
> Sean

try this rough draft to see if does what you want:

a. create new form in design view with Table selected for it to be based on
when you open that.....

b. your table field names will pop-up in a window and highlight drag all
those over into the form.

c. next select ComboBox from the ToolBar and put that on the form and when
the wizard starts for it be sure to select the third lowest radio button
option that it be based upon that same table....

c2 ....select whatever field from that table you want the combobox to refer
to....

Now go to form view and you should see that the combobox drop down will
bring up the record you select & show in the text boxes you dragged over....

it should also work with typing into the combo box with auto complete....

then tweak from there.....
--
NTC


"sheelen" wrote:

> Hi All,
>
> I should start by thanking you for taking the time to address my inquiry, as
> well as admitting that I have absolutely zero experience w/ programming in
> Access. So, if you are kind enough to offer a code or expression to help me
> out, please understand that I may need some serious assistance getting
> through it.
>
> That having been said, I have a question. I have a form - "Data Entry" -
> that has 20+ fields. The database contains over 100 records. I have been
> asked to update the database (which I did not originally design) to do the
> following:
>
> When the person entering information into a new record in the "Data Entry"
> form enters information that has been previously entered, the form should
> either:
>
> 1. Revert immediately back to the record containing the already submitted
> information; or
>
> 2. Auto-Fill in all remaining fields in the new record.
>
> My understanding is that I should use a combo box. However, I have only
> been able to have the combo box select the field that it is referring to, but
> not fill in any of the other fields.
>
> Thank you,
> Sean