searching

[cassie07]

I have added new records to a database via form, but when I go to search for
the new record again using "FIND" it cannot find the record.

Old records can still be found using this method and I know the new record
is there as I can see it in the table but the find cannot see it.

Urgent, please help

 

[Jerry Whittle]

With the form open, go up to Records on the Menu and select Refresh. See if
that works.

 

[cassie07]

Thanks Jerrry, Unfortunately this has not solved the problem.

I know the record no 532 is there as I can see it in design view and when I
add new records 533 onwards they are also in design view but can not be
found using the "FIND" function in Form view. Old records say 530 or 531 can
be found in form view, so it seems something has changes from 532 onwards.

Any ideas?

 

[Pat Hartman \(MVP\)]

Make sure that the form's DataEntry property is set to No and make sure that
there are no filters active and that your form's RecordSource query has no
criteria that will exclude records.

When the form's DataEntry property is set to yes, the form opens to a blank
record. You can add new records and all the records you add while the form
is open are visible and searchable. But, once you close the form, and
reopen it, you start fresh again with an empty recordset even though many
records exist in the table.

 

[cassie07]

Thank you Pat,

I have since found out that there is a bug in the system which means that if
all the tabs and fields are not compelted in the form then you can not
find/view the record unless you go into the table design as an administrator.

 

[Pat Hartman \(MVP\)]

Perhaps you should define relationships and enforce referential integrity.
This will prevent orphan children from being created.