need held with a subform

[sesling]

I have an unbound form (A). The form contains lists boxes that get information from different tables. When the form is opened the lists are populated with various bits of data. The operator will select certain items from the list boxes.

I have a query (Z) that uses the information the operator selects on form (A). This information is listed in the criteria section of the query.

I have a form (B) that is bound to query (Z).

On form (A) I have a command button that will open form (B). This works great.
All data from query Z is displayed.

I created a subform (C) on form (A) that should display the results that appear in form (B). I am not sure how to change the command button code to make this happen. Does anyone have any idea's? I have listed the command code I am currently using.


Private Sub Command34_Click ()
On Error GoTo Err_Command34_C lick

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "B"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command34_ Click:
Exit Sub

Err_Command34_C lick:
MsgBox Err.DESCRIPTION
Resume Exit_Command34_ Click

End Sub

[Rabbit]

You'll want the button to requery the subform.

[sesling]

You'll want the button to requery the subform.

ok. would I keep the existing code in the onclick command or would that need to change? if so, how?

[Rabbit]

You'll need to change it because I'm assuming you want to go with a subform instead of using a second form. So obviously you'll want to get rid of that line.

A requery is usually done using the Requery method of the control.

[sesling]

You'll need to change it because I'm assuming you want to go with a subform instead of using a second form. So obviously you'll want to get rid of that line.

A requery is usually done using the Requery method of the control.

Sorry but I am not following what needs to be done. How would I change the current command control (see original post) to run the requery? How would I reference the subform in the requery command? Don't I still need to call the original form or query to get the data to display?

[Rabbit]

Sorry but I am not following what needs to be done. How would I change the current command control (see original post) to run the requery? How would I reference the subform in the requery command? Don't I still need to call the original form or query to get the data to display?

The requery is simply Me.subformcontr ol.Requery. I'm not sure what you mean by calling the original form or query to get the data to display.

[sesling]

The requery is simply Me.subformcontr ol.Requery. I'm not sure what you mean by calling the original form or query to get the data to display.

My new command button (on-click) code is listed below. FILETYPE is the name of the subform. When I click on the command button I do not see the results of the query. If I go into edit mode on the form and then back to view the results are populated on the form. Am I missing another step?

Private Sub Command34_Click ()
On Error GoTo Err_Command34_C lick

Me.FILETYPE.Req uery

Exit_Command34_ Click:
Exit Sub

Err_Command34_C lick:
MsgBox Err.DESCRIPTION
Resume Exit_Command34_ Click

End Sub

[Rabbit]

Try Me.Filetype.For m.Requery

[sesling]

Try Me.Filetype.For m.Requery

Tried that and got the same result. Are there any other things I can try?

[sesling]

Try Me.Filetype.For m.Requery

I think I found what I was doing wrong. See my code below. This seems to work.

Private Sub Command34_Click ()
On Error GoTo Err_Command34_C lick

Me.FILETYPE.sou rceObject = "queryZ"

Exit_Command34_ Click:
Exit Sub

Err_Command34_C lick:
MsgBox Err.DESCRIPTION
Resume Exit_Command34_ Click

Me.Filetype.For m.Requery

End Sub

However this leads to my next issue. On the subform are file records that contain ID's. When I use the original form that the subform is based on I can double click on the file and the ID is passed to another query and those results appear on the screen. Again my query criteria has forms!formB!FIL EID. Now that the information is being displayed in the subform how can I get the double click option to work? When I look at the properties for the subform there are no options for onClick or onDblClick. When I double click on the item i get a screen pop up that requests to value for forms!formB!FIL EID. I tried changing the query criteria to forms!FILETYPE! .ID but that did not work. I know how to pass a value from a form to a query but is it even possible to pass a value from a subform to a query? If so, how?