Search macro that only open the one record in the form PLEASE HELP

[Diane]

I have a search macro that is search from a command button on a form. Here is
my problem. when I use the search it only open the one record you can not
then page and see any of the other records. you can close the form and
re-open it and then see all the records. Please help what am I doing wrong
or not seeing. I have been fighting with thing on an off for days. I would
really appreciate any and all help !!

Thanks!!

 

[Ken Snell \(MVP\)]

Please reword your question a bit more clearly... I'm not understanding your
problem.. seems to be something about wanting to open a second form that
shows just a single record, and then somehow the form shows more than just
that one record? Give us details about the macro's actions too.

 

[Steve Schapel]

Diane,

It appears your macro is restricting the records on the form to only the
record you searched for. Without knowing the details of your macro and
your forms, it's not clear how this is happening. Maybe you are using
an OpenForm action with the Where Condition argument set. Maybe you are
using a SetValue action to toggle the RecordSource property of the form.
Maybe the form is based on a query that has a reference to your search
criteria input control. So how to correct it will depend on what the
actual process is. It may be more applicable, if you want to navigate
from the selected records to the other records, to use a FindRecord
macro instead of whatever you've got now. Alternativley, you may need
to put a command button on the form, with a macro to "undo" whatever
your seach procedure does.