Message box to display information based on expression

[d-mcc56]

hey guys,

I have a searchable form that display information on agreements other companies have with us. If a company requests an inspection we have 30 days to go out and complete it.

I am trying to create a message box that will display all inspections that are due within 5 days when the form loads. No luck so far, only broken dreams.

Is it possible for message boxes to use expressions and display information that fits the criteria? If so, guidance would be greatly appreciated

Thanks!

 

[plog]

Yes it is possible and my guidance is to not use a message box to display the data. I'd create a report for that. You can use a message box to direct the user to open that report, or better yet, automatically display it if the number of inspections due in 5 days is greater than 0.

This isn't high level VBA we are talking about, so I'm guessing you are relatively new to it. My suggestion is to google a few tutorials and start practicing.

Or, post what you have so far and we can help step you through it.

 

[d-mcc56]

I didn't even think of using a report, yikes.

Thanks for the reminder on that one, if I get stuck I'll be back