start new record on form

[Guest]

I have created a Form which is based on two tables. One table is purely for
looking up relevant data so data gets automatically populated into a fields
after it has been searched by a unique reference number (ECMA). The other
table is to store the data in so that records can be searched at a later
time. The problem is that I am searching by ECMA number and old records are
showing up. What I want to be able to do is search by ECMA number and a new
Record to start. I already have another unique number where old Records can
be searched on. Please help.

 

[Rick Brandt]

I have created a Form which is based on two tables. One table is
purely for looking up relevant data so data gets automatically
populated into a fields after it has been searched by a unique
reference number (ECMA). The other table is to store the data in so
that records can be searched at a later time. The problem is that I
am searching by ECMA number and old records are showing up. What I
want to be able to do is search by ECMA number and a new Record to
start. I already have another unique number where old Records can be
searched on. Please help.

I fail to understand how a search can result in a new record. Surely by
definition, a search is going to take you to an existing record.

 

[Guest]

I want to search from the look up table which will populate a number of
fields so data entry is not required by the users. But this has to start a
new record.

 

[Rick Brandt]

I want to search from the look up table which will populate a number
of fields so data entry is not required by the users. But this has to
start a new record.

Normally you would move to the new record and then make a selection from a
ComboBox that would set the foreign key value to the lookup table. Copying data
from the lookup table (besides the key field) would in most cases be an
incorrect thing to do.

Once you have the foreign key populated the query join will *display* the other
fields from the lookup table.