Search Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that is backed by a table with 30,000 records. I need to
search the table in order to update each individual record. There are about
1,500 records that are duplicated. I need the search to bring up all
occurences of the record in the table so the correct record can be updated.
I was trying to create a subform that would bring up all occurances. Then I
would need to select the correct record to update, but I do not know how to
make the record selected in the subform populate the main form.

Any help would be greatly appreciated.

thanks in advance
 
It's not clear what you're trying to do. First, do you want to keep the
duplicate records or get rid of them? Also, do you want to update a single
field with the same value, which is easy, or something more complicated?
In any case I don't believe you need a subform to examine the records
individually, that would be very time consuming.
 
Thank you for responding,

My table has a blank field that I need to update with a status for the
record. My table has a field for item number and one for company. There is
the same item number showing for 2 different companies therefore there would
be two records in the table. I want to select the correct record to update
by the company name. That is why I wanted a subform to bring up all
occurances of the item within the table.

Hope this helps you understand what I am trying to do.

Thanks,
 
OK, this makes sense, but why are you updating the record for one company
and not the other? In other words, even if you had a subform, what other
piece of data are you looking at to know which company record to update?
For example, if you want to update the record for all companies that sold
some item on 10/15/04 (or some other timeframe), you might use this as an
additional criteria to isolate what records you want to update. It seems
like there might be some other "additional criteria(s)" already in the
database that will let you target the records you want to update without
having to look at all 1500 or more individually (or heaven forbid you intend
to manually scroll through all 30,000, looking for the 1,500 dupes, and
deciding which dupe to update, which would require you to repeat the same
decision 1,500 times - we have computers to avoid just such tedium.)
 
Back
Top