Selecting by Name or Number

[DP]

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]

Of course, you could parse the field, extract its numeric portion and alpha
portion, but I think the easiest way is to simply match a substring:

"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