sub form visable 1

[end922]

Hello,
I am working with a main form with several subforms. Upon open of the main form the sub forms are set to visable = false. I have a command button that make a particular form visable when clicked. Only 1 form at a time. After updating the form I want to save and close with a command button on click and make that form visable = false. That's where I get hung up.

frmBorrower is main form.
subfrmbilling is sub form.
subfrmdisb is sub form.

Thanks
eric

 

[Remou]

Are you having a problem with setting the visible property? Where are you running the code to save and set visible to false? That is, what form and what event?

 

[TheAceMan1]

How are ya end922 . . .

Also . . . after you save you need to move the focus off the subform if you intend to hide it again! [purple]You can't hide a control while it has the focus! . . .[/purple]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

 

[end922]

Remou,

I was having problems. I moved the cmd button from the subfrm to the main form and set the focus there. Now I can't get my macro to run. Any help on this would be appreciated.
Thanks


Private Sub cmdsave_Click()

Dim billsave As String
billsave = mcrobilling

DoCmd.RunMacro billsave

Me.txtassignedto.SetFocus

subfrmbilling.Visible = False
subfrmbilling.Enabled = False

Exit Sub

End Sub

 

[Remou]

It seems that the macro needs the focus to be set to the subform before it will work. Alternatively, you could move the macro back to the subform and move the focus before you change the visible property:

[tt]Me.Parent.NameOfAControlOnTheMainForm.SetFocus
Me.Visible = False[/tt]