B
Bari
I am pretty new at this, but have created a Query Form
which runs with a Query (of course). My problem is I can
create a Like paramter query (searching for every record
containing the word "Van" for example - Like "*" & [Enter
any char to search by: ] & "*") no problem, and create a
QBF that links to a query with no Like/wildcard using the
formula ([Forms]![Shareholders Name Search]!
[Stockholder's Name & Address]). My dilema is that I
want my QBF to use the Like query. I referenced MKBA
209645 it says it can be done by:
Like Forms! FormName!ControlName & "*" Or Forms!FormName!
ControlName Is Null With this I receive all records
but the entry I type into my form. Seems like a simple
request, can anyone assist?
Using Access 2002.
Thank you!
which runs with a Query (of course). My problem is I can
create a Like paramter query (searching for every record
containing the word "Van" for example - Like "*" & [Enter
any char to search by: ] & "*") no problem, and create a
QBF that links to a query with no Like/wildcard using the
formula ([Forms]![Shareholders Name Search]!
[Stockholder's Name & Address]). My dilema is that I
want my QBF to use the Like query. I referenced MKBA
209645 it says it can be done by:
Like Forms! FormName!ControlName & "*" Or Forms!FormName!
ControlName Is Null With this I receive all records
but the entry I type into my form. Seems like a simple
request, can anyone assist?
Using Access 2002.
Thank you!