Hey everyone!
I have a form that my users fliter and push to reports. If there are no returns in the filter, the form just goes blank. Not no-data blank, but all my controls, everything, dissapears. I read a thread reccomending putting an invisible control with the Control Source as =Count(*). Then put some statement on it that checks if the count returns 0, and if it does, add a message box = "no reccords match..." and then go back to the form.
I'm not sure if this is the correct way to attack this, and if it is, where do I put this event that checks for reccords? I already have events on current, update and after update of my form. Does that matter? Can you have more that one procedure in each event? Should it be attached to the control instead?
Thanks all!
Holy tek-tips batman!:-0
I have a form that my users fliter and push to reports. If there are no returns in the filter, the form just goes blank. Not no-data blank, but all my controls, everything, dissapears. I read a thread reccomending putting an invisible control with the Control Source as =Count(*). Then put some statement on it that checks if the count returns 0, and if it does, add a message box = "no reccords match..." and then go back to the form.
I'm not sure if this is the correct way to attack this, and if it is, where do I put this event that checks for reccords? I already have events on current, update and after update of my form. Does that matter? Can you have more that one procedure in each event? Should it be attached to the control instead?
Thanks all!
Holy tek-tips batman!:-0