I have 2 tables
WHSender (Sender, Phone, SenderID) and WHSend (SenderID, Sender)
In the form I have a combo box with sender's names and I have a list box called Sender Phone .. Whenever the user choose and sender name I want the sender phone to change regarding the sender name ...
Does this make sense ... ???
Maybe am doing it wrong .. can someone please help me
I have used LIKE with/without a wildcard and it worked for me.
For instance, a combo box on a form with definitive selections for query criteria, and a "*" added to the rowsource in case you want to pass all records...
In the query, I use LIKE Forms!MyForm!cboCriteria. If you select the asterisk, you get everything...if you select a criteria, you just get that.