I have a query that calculates inventory levels at future dates for rental equipment. I have a parameter for a start and end date so it can search for orders between those two dates and I have been trying to make it so that the end user cannot just click through and have no dates entered for the parameter but haven't had much luck. Is their a way to do this? So far the only solution I've found is to put the date selection on a form and set the validation rules this way but I prefer the pop up if its possible.
Kevin Robertson
@Reply 3 years ago
I would use Input Boxes in VBA if you want to intercept the user interaction.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.