| | |
|
|
|
Selecting by Name or Number |
|---|
| message from DP on 2 Jun 2004 |
Is there a way to select an item based on knowing either
the Number or Name. (I'm using Combo boxes). Example would
be to eventually find "1160 Broadway" by entering either
1160 or Broadway.
I suppose one combined query of Numbers and Names might
work for the first combo where the second combo is limited
to the results of the first selection. It seems like a
complication to build that query, is there an easier way?
|
| Graham R Seach replied to DP on 3 Jun 2004 |
"SELECT * FROM tblMyTable WHERE [Address] LIKE *""" & Me!cboMyCombo & "*"""
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
"DP" <anonymous@discussions.microsoft.com> wrote in message
news:1745601c448b2$b966ff10$a001280a@phx.gbl...
|
|
Archived message: Selecting by Name or Number (MS Access Forms)
