search field not working on form!

  • Thread starter Thread starter Maritza
  • Start date Start date
M

Maritza

Hi,

I have a database someone else created, who is no longer
here. The database is complicated and has lost of queries,
forms, modules, reports, linked tables etc. The problem I
am having is the following:

One of the forms when I search for a block of records, it
says the record is not found. I can find records from 1-
4886 then from 7904 to end of database. I cannot search
anything from records #'s 4887 to 7904 it gives me an
error message "ID not found" Can anyone help me with this?
Could it be some programming written that would block
records on this particular form. I can use another form
and find it with no problem.

Thank you for any help I can get.

Maritza.
 
Maritza said:
Hugh,

I am sorry but maybe I did not explain myself right. The
numbers I am looking at 1000-4886 are the record ID each
sister uses, just like a social security number. It is not
an auto number. The curious thing is, when I search on the
database for the number 4887, 4888, 5001, 9001 etc. the
records are there. For example in the retirement form they
appear, but when you look in the patrimony form is when I
get that sister id 4887 not found error message. Records
are there, they have not been deleted. I can find them in
database. Error message only occurs on the records from
4887-7903. If I search for 4886 it pulls the record, same
if I search for 7904. This is why I thought maybe you
could block a series of number with coding.

Hope this makes more sense.

Thanks,

Maritza.
Click to expand...


Since the records you are looking for are in the Table, there is some
filter which is preventing them from being returned into your form.

The first place I would look is the Query on which the form is based.
Is there a selection criterion set, possibly for the Field containing
the number series?

If the form based directly on the Table with no Query, then I would
look at the Form's code using the vba editor. There is probably an SQL
in there doing some selection.

hth

Hugh
 
Back
Top