subforms

[round]

Hello all,

Please can somebody help me, I'm guessing its a fairly simple q...

I have a form with a search for record section which then populates 2 sub forms within the same form.

How do I make the subforms invisible until they have searched and selected the record they wish to view??

I have set the visible property to no on the subform and then changed the afterupdate of search field to include

me.suformname.visible = true

and it creates an error. What am I missing??

Many Thanks

 

[ajetrumpet]

Form_Load

  Me.SubFormContainer1Name.Visible = False

ComboBox1_AfterUpdate

  Me.SubFormContainer1Name.Visible = True

End Sub

Wouldn't this be easier if it was all combined into one post....???

 

[round]

Ok great, thanks again ajetrumpet.

Sorry about mutli posting, I thought as it was a different query I should start a new post, but point taken.