invisable form

[chaosguy]

hey I wanna like make a form invisable so that i can pull a value from one of it's field for a report using a textbox in the report. The form would be like open, or u can call values from the form, but I don't want the user to see the form. so is there anyway I can make a form open everytime a report is opened and close when it gets closed, but it should run in the background or invisible . can anyone help?

it would be appriciated.

Chaosguy - To die would be an awefully big adventure.

 

[Remou]

This:

Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenForm "Form1", , , , acFormReadOnly, acHidden
End Sub

Would open a form called Form1 as read only and hidden when a report opens.

 

[TheAceMan1]

How are ya chaosguy . . .

Likewise, in the reports [blue]Close[/blue] event:

[blue]   docmd.Close acform, "FormName"[/blue]

See Ya! . . . . . .

 

[chaosguy]

okay i'll try these and see what happens. thanks

Chaosguy - To die would be an awefully big adventure.