View query results in MsgBox

  • Thread starter Thread starter maceslin
  • Start date Start date
M

maceslin

I have developed qryQuickLook that brings up rptQuickLook when
cmdQuickLook is clicked, everything works great but I would rather see
the results (never more than 10 line items) in a MsgBox than have a
seperate report window open up. Is there a way to do this?
Thanks
Dave
 
Why "MsgBox"? You can display the results in a dialog form with a command
button or two.
 
Why "MsgBox"? You can display the results in a dialog form with a command
button or two.

--
Duane Hookom
Microsoft Access MVP





- Show quoted text -
Click to expand...

Sounds like a viable option that someone with more experince has. Can
you give me more on how to do this?
 
Create a new form that is 4"x6" with no Control Source.
Scroll Bars: No
Record Selectors: No
Navigation Buttons: No
Dividing Lines: No
Auto Center: Yes
Popup: Yes
Modal: Yes
Allow Design Changes: Design View Only

Use the control wizard to add a command button that closes the form.

Add a subform control on the form. Set the subform control's source object.
Source Object: Query.qryQuickLook

Save the form as "frmQuickLook"
 
Create a new form that is 4"x6" with no Control Source.
Scroll Bars: No
Record Selectors: No
Navigation Buttons: No
Dividing Lines: No
Auto Center: Yes
Popup: Yes
Modal: Yes
Allow Design Changes: Design View Only

Use the control wizard to add a command button that closes the form.

Add a subform control on the form. Set the subform control's source object.
Source Object: Query.qryQuickLook

Save the form as "frmQuickLook"
--
Duane Hookom
Microsoft Access MVP






- Show quoted text -
Click to expand...

Thanks- works great
 
Back
Top