Filter on Current Record

[REGREGL]

Hello all...

I have a form (formA) witha subform (formB). The subform is set to
continuous records view. I would like to have a button within the subform
which will open another form (formC) and filter formC by the currently
selected record in formB.

Now, I would have no problem with this if formB were set to Single View. In
that case I could create a filter and use the criteria [forms]![formB]![Order
Number] to accomplish what I want. But with the form view set to Continuous
Records, the filter criteria doesn't understand which [Order Number] to use.

Thanks in advance for your help!

 

[NetworkTrade]

I do not believe that one can put a subform within a continuous form....

 

[Jeanette Cunningham]

If I have understood your request, the button uses the current ID for formB
to open formC using a filter like this:

Private Sub cmdOpen_Click()
DoCmd.OpenForm "formC", , , "[KeyID] = " & Me.txtID & "" 'number field
'DoCmd.OpenForm "formC", , , "[KeyID] = """ & Me.txtID & """"
'text field
End Sub

That code will open formC to show just the details for the currently
selected record in formB.

Jeanette Cunningham

 

[REGREGL]

What is supposed to replace the "me.txtID"? I have replaced the "formC" and
"[key ID]" fields with the relevant data. But it sticks when it gets to
Me.txtID.

If I have understood your request, the button uses the current ID for formB
to open formC using a filter like this:

Private Sub cmdOpen_Click()
DoCmd.OpenForm "formC", , , "[KeyID] = " & Me.txtID & "" 'number field
'DoCmd.OpenForm "formC", , , "[KeyID] = """ & Me.txtID & """"
'text field
End Sub

That code will open formC to show just the details for the currently
selected record in formB.

Jeanette Cunningham

Hello all...

I have a form (formA) witha subform (formB). The subform is set to
continuous records view. I would like to have a button within the subform
which will open another form (formC) and filter formC by the currently
selected record in formB.

Now, I would have no problem with this if formB were set to Single View.
In
that case I could create a filter and use the criteria
[forms]![formB]![Order
Number] to accomplish what I want. But with the form view set to
Continuous
Records, the filter criteria doesn't understand which [Order Number] to
use.

Thanks in advance for your help!

 

[Jeanette Cunningham]

Make sure your subform has the foreign key from its recordsource as a bound
textbox on it - the field that is used in the Master child links - make sure
it is a control on the subform.

Replace ID with the name of that field
I used txt as the prefix for the name of the textbox, this is the way I do
naming.
If the linking field was called OrderID, I would call the text box
txtOrderID.
We are using txtOrderID because it is the thing that identifies which row on
the subform to filter on when opening formC.
Does this explain it?

Jeanette Cunningham

What is supposed to replace the "me.txtID"? I have replaced the "formC"
and
"[key ID]" fields with the relevant data. But it sticks when it gets to
Me.txtID.

If I have understood your request, the button uses the current ID for
formB
to open formC using a filter like this:

Private Sub cmdOpen_Click()
DoCmd.OpenForm "formC", , , "[KeyID] = " & Me.txtID & "" 'number
field
'DoCmd.OpenForm "formC", , , "[KeyID] = """ & Me.txtID & """"
'text field
End Sub

That code will open formC to show just the details for the currently
selected record in formB.

Jeanette Cunningham

Hello all...

I have a form (formA) witha subform (formB). The subform is set to
continuous records view. I would like to have a button within the
subform
which will open another form (formC) and filter formC by the currently
selected record in formB.

Now, I would have no problem with this if formB were set to Single
View.
In
that case I could create a filter and use the criteria
[forms]![formB]![Order
Number] to accomplish what I want. But with the form view set to
Continuous
Records, the filter criteria doesn't understand which [Order Number] to
use.

Thanks in advance for your help!

 

[REGREGL]

Thank you very much Jeanette, that did the trick!!!

Make sure your subform has the foreign key from its recordsource as a bound
textbox on it - the field that is used in the Master child links - make sure
it is a control on the subform.

Replace ID with the name of that field
I used txt as the prefix for the name of the textbox, this is the way I do
naming.
If the linking field was called OrderID, I would call the text box
txtOrderID.
We are using txtOrderID because it is the thing that identifies which row on
the subform to filter on when opening formC.
Does this explain it?

Jeanette Cunningham

What is supposed to replace the "me.txtID"? I have replaced the "formC"
and
"[key ID]" fields with the relevant data. But it sticks when it gets to
Me.txtID.

If I have understood your request, the button uses the current ID for
formB
to open formC using a filter like this:

Private Sub cmdOpen_Click()
DoCmd.OpenForm "formC", , , "[KeyID] = " & Me.txtID & "" 'number
field
'DoCmd.OpenForm "formC", , , "[KeyID] = """ & Me.txtID & """"
'text field
End Sub

That code will open formC to show just the details for the currently
selected record in formB.

Jeanette Cunningham


Hello all...

I have a form (formA) witha subform (formB). The subform is set to
continuous records view. I would like to have a button within the
subform
which will open another form (formC) and filter formC by the currently
selected record in formB.

Now, I would have no problem with this if formB were set to Single
View.
In
that case I could create a filter and use the criteria
[forms]![formB]![Order
Number] to accomplish what I want. But with the form view set to
Continuous
Records, the filter criteria doesn't understand which [Order Number] to
use.

Thanks in advance for your help!