subform openform

[slimjen]

All, I closed a thread similar to this. I have a form with two subforms. I created a txt control to link the two subforms together. The 2nd subform is not linked to the main form; only the 1st subform. I put a cmdButton on the 2nd subform to open a popup form in datasheet view. I am having trouble with referencing the two subforms so only records from the selected details appear. For my other popup form; I put a cmdButton on the main form to open records result in the 1st subform:

    DoCmd.OpenForm "popupFormName", , , "CustID = " & Me.CustID

Works great. But won't work with the two subforms. I tried: DoCmd.openform "popupFormName", , ,"subform1.txtControl= " & Me.Control

I hope I explained this clearly. Obviously; I'm doing something wrong...Please help

[June7]

It's not totally clear what you want.

Button and code are on main form and the parameter you want is on subform?

Reference a field in RecordSource of popup form that needs to be filtered.

If the field is text type, use apostrophe delimiters.

DoCmd.openform "popupFormName", , ,"fieldname = '" & Me.subformcontainer.controlname & "'"

[slimjen]

Gm ..thanks for replying..I apologize I didn't make myself clear..I have the too subforms linked on the mainform n when the 1st subform is filtered to a record, the 2nd subform filters the corresponding record. But the 2nd subform has many records so I made another form to open in datasheet view so users can see all records at one time. I was able to do this for the 1st subform because it was linked to the main form with the code n was able to put the button to open the popup form. I referenced but having a problem with the code I put on the 2nd subform to tie in with the 1st subform

[June7]

You want to open a popup form from each subform? Code for 1st subform works but code for 2nd subform doesn't? If button is on 2nd subform, your original code should work.

Why don't you just have 2nd subform in datasheet view?

If you want to provide db for analysis, follow instructions at bottom of my post.

[slimjen]

Took ur advice and opened in datasheet view..thanks