Report button in Form

[drobizzle]

First time poster. I made a button via macro in a Form to link me to a Report (I have three different versions for three different languages) I want to be able to choose the language of the report it opens with a popup box. Can it be done or can it be done only with a box where I would write the Report name? Thanks in advance. P.S. Will I have to make three different buttons?

[June7]

By 'popup' do you mean the intrinsic InputBox or a custom popup which is really just a form? The first is easy to create and pass value to the calling form but harder to control validation.

Why not just a combo or list box on the form that offers the three choices? This control can be referenced in code to open the report.

Could even automate the language selection if you associate a language with client.

[drobizzle]

I never thought of a form. So I made a new form put the three buttons that show reports in different languages and an exit button. I made it as a pop-up: Form properties/Property sheet/other/pop up - yes. The thing is how do I center the pop up box in the middle of the screen. It goes randomly from the top left corner to sort of somewhere in the middle but not quite.

[June7]

Try setting the form AutoCenter property to Yes. So where is code to open the report - behind each of the language buttons?

[drobizzle]

It is set to yes still no luck.

[June7]

Not sure if this is a fix, I never set the Popup property to yes. I have set Modal to yes. Only do that when finished coding, Modal interferes with debugging.