Search KeyWords

[SoxPats83]

Simply use;

Me!Subform1.Form.Visible = True

or

Me!Subform1.Form.Visible = False

and that would be on the main form's OnLoad event? and after i enter that, how do i make them visible again after making the selection?

 

[John Big Booty]

You would put that on any event that you want to trigger the Sub form to be either visible or hidden. When you able to have a look at the sample I posted earlier you will see I have the code in the On Current event as well as the buttons On Click event.

Book mark this link for a handy reference for the correct syntax for addressing subforms, their properties and controls.

 

[SoxPats83]

Simply use;

Me!Subform1.Form.Visible = True

or

Me!Subform1.Form.Visible = False

You'll have to excuse me on this question, but on the qouted coding here, are you using the term "Subform1" as the name of the attached subform?

 

[John Big Booty]

Replace the generic Subform1 with the name of your sub form.

 

[SoxPats83]

Replace the generic Subform1 with the name of your sub form.

so theoretically... i insert my subform. go into the properties of that subform and change the visible to no (would this work the same as inserting the visible=false). then in the double click event of the list box, i insert the visible=true part?

 

[John Big Booty]

No because once you have change a property using code, that's the way it will stay until you change it again with some more code.

 

[SoxPats83]

something odd... i am getting an "Enter Parameter Value: Forms!FRM_SearchMulti!SrchText" error. not everytime but sometimes i do. defenitely every time i open the query.

 

[John Big Booty]

I'm guessing that this will be happening when the form FRM_SearchMulti is not open or open in design view. As the query is drawing criteria from this form it will ask you to "Enter Parameter Value:" when it is unable to get it from the form.