I have a form that has two subforms
I want to seacrh on what is on the suforms by using the
find record command. However, I can only search on the
main form fields..can anyone tell me why and how I can
fix this? Thank you in advance for your time and help.
Mary

You could use the subform's RecordsetClone and its FindFirst or FindNext
methods.

From the main form:

Me.SubformName.Form.RecordsetClone.FindFirst "[FieldInSubform] = " &
SomeValue
Me.SubformName.Form.Recordset.Bookmark =
Me.SubformName.Form.RecordsetClone.Bookmark

where SubformName is the name of the subform control on the main form that
is actually holding the subform object.

--
Ken Snell
<MS ACCESS MVP>

"Mary" <(E-Mail Removed)> wrote in message
news:0f3101c37f7b$be6d3980$(E-Mail Removed)...
> I have a form that has two subforms
> I want to seacrh on what is on the suforms by using the
> find record command. However, I can only search on the
> main form fields..can anyone tell me why and how I can
> fix this? Thank you in advance for your time and help.
> Mary
>

how does this work fro two subforms? or it doesn't?


>-----Original Message-----
>You could use the subform's RecordsetClone and its
FindFirst or FindNext
>methods.
>
>From the main form:
>
>Me.SubformName.Form.RecordsetClone.FindFirst "[FieldInSub
form] = " &
>SomeValue
>Me.SubformName.Form.Recordset.Bookmark =
>Me.SubformName.Form.RecordsetClone.Bookmark
>
>where SubformName is the name of the subform control on
the main form that
>is actually holding the subform object.
>
>--
> Ken Snell
><MS ACCESS MVP>
>
>"Mary" <(E-Mail Removed)> wrote in message
>news:0f3101c37f7b$be6d3980$(E-Mail Removed)...
>> I have a form that has two subforms
>> I want to seacrh on what is on the suforms by using the
>> find record command. However, I can only search on the
>> main form fields..can anyone tell me why and how I can
>> fix this? Thank you in advance for your time and help.
>> Mary
>>
>
>
>.
>

I'm not understanding you.... two subforms? You mean a subform within a
subform?

--
Ken Snell
<MS ACCESS MVP>

"mary" <(E-Mail Removed)> wrote in message
news:9b0e01c3803f$619a4120$(E-Mail Removed)...
> how does this work fro two subforms? or it doesn't?
>
>
> >-----Original Message-----
> >You could use the subform's RecordsetClone and its
> FindFirst or FindNext
> >methods.
> >
> >From the main form:
> >
> >Me.SubformName.Form.RecordsetClone.FindFirst "[FieldInSub
> form] = " &
> >SomeValue
> >Me.SubformName.Form.Recordset.Bookmark =
> >Me.SubformName.Form.RecordsetClone.Bookmark
> >
> >where SubformName is the name of the subform control on
> the main form that
> >is actually holding the subform object.
> >
> >--
> > Ken Snell
> ><MS ACCESS MVP>
> >
> >"Mary" <(E-Mail Removed)> wrote in message
> >news:0f3101c37f7b$be6d3980$(E-Mail Removed)...
> >> I have a form that has two subforms
> >> I want to seacrh on what is on the suforms by using the
> >> find record command. However, I can only search on the
> >> main form fields..can anyone tell me why and how I can
> >> fix this? Thank you in advance for your time and help.
> >> Mary
> >>
> >
> >
> >.
> >