Msgbox Combo Question

[Steve_Bache]

Can someone put me on the right track ?

I have a command button on a switchboard , that runs a report from a query. When requested, a Msgbox appears allowing maual entry of a specific 'Request No' that the query uses to pull the relevant data from a table. So far,so good!

I wish to change this so that when the button is clicked , a combo box appears to allow selection either via the drop down or still by manual entry.

I haven't a clue as to whether this is possible ( sounds straight forward enough) or what the best method would be.

I've been trawling through the forum without any clear ideas.Any help would be appreciated.

Steve

 

[Matt Greatorex]

Would it be an option ot have said combo box on the form and just make it visible at the correct moment?

If it wasn't set to 'Limit to List', you could either pick a value or enter it.

 

[Steve_Bache]

Thanks

Hi Matt,

I'm trying to keep a consistent look and feel to the switchboard - I have 9 buttons on there, several of which are used to request report previews. I wanted to retain this format if possible. Am I trying to do the impossible ?

Cheers

Steve

 

[Matt Greatorex]

How about if a certain condition is met, you open a form with the combo box on it?

 

[Steve_Bache]

Matt,

Doing some more digging around, I think my best option is to get the button to create a form with the combo box on it and take it from there. Thanks for your suggestions.

Cheers


Steve