jkfeagle
Codus Confusious
- Local time
- Yesterday, 20:18
- Joined
- Aug 22, 2002
- Messages
- 166
I have a form that query's the operator for input values. They then click on a button on the form that runs a series of queries culminating in a make table query that contains the desired data and then displays this data in a continuous form that pops up. There WILL be times when the returned data set is null. During those times I want the pop up form to display a text box stating there was no matching data. Obviously, when there is data I want it displayed.
All works well except I can't get the no data message to appear when the data set is empty. I'm using code for the On Open event that looks to one of the main text boxes that would contain data if there was any to see if it appears as null. Apparently, from what I've been able to gather, when there is no data in the underlying table, the text box is defined but does not hold ANY value, thus no value test can be performed on it (Is Null, = "", etc.). So what I end up with is a form with a completely blank detail section instead of my text box indicating no matches were found.
Am I assuming correctly? If so, how do I get around this? Thanks in advance for any help!
All works well except I can't get the no data message to appear when the data set is empty. I'm using code for the On Open event that looks to one of the main text boxes that would contain data if there was any to see if it appears as null. Apparently, from what I've been able to gather, when there is no data in the underlying table, the text box is defined but does not hold ANY value, thus no value test can be performed on it (Is Null, = "", etc.). So what I end up with is a form with a completely blank detail section instead of my text box indicating no matches were found.
Am I assuming correctly? If so, how do I get around this? Thanks in advance for any help!
