S
Sandy Modesitt
Hello,
I have a form with a subform and am having troubles searching for data in
the subform. When I try to Find a value in the subform's field, it says it
isn't found.
Background:
The forms are linked correctly - as I scroll through the forms, the subforms
keep in synch.
When I click in the subform and then click the Find icon (binoculars), there
are 2 places to "Look In" - the subform and the field Agency Name. I try
both of them and don't find the value. I verified that the "Any part" is
selected.
I have tried putting a search button on the subform - it works correctly
when I open the subform itself but not when opened on the form where it is a
subform.
The source for the subform is a query (SELECT [Agency_Info].[Agency Number],
[Agency_Info].[Agency Name] FROM Agency_Info; )
Thanks for any help that is provided.
Sandy
I have a form with a subform and am having troubles searching for data in
the subform. When I try to Find a value in the subform's field, it says it
isn't found.
Background:
The forms are linked correctly - as I scroll through the forms, the subforms
keep in synch.
When I click in the subform and then click the Find icon (binoculars), there
are 2 places to "Look In" - the subform and the field Agency Name. I try
both of them and don't find the value. I verified that the "Any part" is
selected.
I have tried putting a search button on the subform - it works correctly
when I open the subform itself but not when opened on the form where it is a
subform.
The source for the subform is a query (SELECT [Agency_Info].[Agency Number],
[Agency_Info].[Agency Name] FROM Agency_Info; )
Thanks for any help that is provided.
Sandy