Hi all,
I have a combo box that successfully queries, getting criteria from 2 unbound controls. It returns either a Null or returns only 1 record. This then becomes the grist of an If, Than, Else statement. Because I want the user to avoid using a mouse to interact with the form, I am told, and believe it a better thing, that I should requery a text box instead of a combo or list box which would eliminate the need to ‘Select’ a record.
I know to use MyTextBox.Requery in my code. Where would I run my query from? Unlike a combo box, a text box isn’t tied directly to a query. I'm guessing that the text box would be bound, but, naturally, it would be bound to my table and I don't know how to get it to show a result of a query? Would it show up as an empty box if the query returned a Null, and show data if it returned with a ‘record found’ like a combo box does when clicked?
Also, is it possible to run an If, Then, Else statement in the criteria section of a query such as: IF DCount("[APartNumber]", etc, etc,.. >0 Than X Else Y?
Thanks in advance,
chuck
I have a combo box that successfully queries, getting criteria from 2 unbound controls. It returns either a Null or returns only 1 record. This then becomes the grist of an If, Than, Else statement. Because I want the user to avoid using a mouse to interact with the form, I am told, and believe it a better thing, that I should requery a text box instead of a combo or list box which would eliminate the need to ‘Select’ a record.
I know to use MyTextBox.Requery in my code. Where would I run my query from? Unlike a combo box, a text box isn’t tied directly to a query. I'm guessing that the text box would be bound, but, naturally, it would be bound to my table and I don't know how to get it to show a result of a query? Would it show up as an empty box if the query returned a Null, and show data if it returned with a ‘record found’ like a combo box does when clicked?
Also, is it possible to run an If, Then, Else statement in the criteria section of a query such as: IF DCount("[APartNumber]", etc, etc,.. >0 Than X Else Y?
Thanks in advance,
chuck