Making form/dialogue box dissappear when user selects from list box

[GoldenFireTiger]

I have a form which I have made into a report. On the form is a list box containing the names of all of the reports on the system. The user selects a report from this list and chooses view. How can I make the dialogue box dissappear when the report is loaded?

 

[grande]

It'd be something like this:

DoCmd.OpenReport "Report Name"
[Forms]![frmSelectReport].Visible = False

Hope this helps!

-------------------------
Just call me Captain Awesome.

 

[TheAceMan1]

How are ya GoldenFireTiger . . . . .

[blue]DoCmd.Close acForm, "YourFormName"[/blue]

See Ya! . . . . . .

 

[GoldenFireTiger]

Grande: thanks for that! Much appreciated!


TheAceman1: I'm fine thanks, yourself? Thanks for the code! would that close the form when a report was viewed?

 

[TheAceMan1]

[blue]would that close the form when a report was viewed?[/blue]

[purple]Use it just before the line that opens the report in your code![/purple]

See Ya! . . . . . .

 

[GoldenFireTiger]

Grande and Aceman, both your menthods work! Thank you both very much!