how do i search a record that i have specified in textbox
-
-
eddy4:
1) with a parameter based query
2) via VBA by building a valid SQL string using the value from the textbox in the WHERE clause and then opening a recordset based on that string.
3) using VBA, calculated field in a query, and/or a calculated control on a form and DLOOKUP() in the criteria string. In VBA I prefer to build the criteria string first first. The value returned depends on what you want to do with the information.
4) Microsoft has several good tutorials on its website and there are other very good tutorials around the net that will also show you this.
5) Visit Allen Browne's website for some basics.
6) goto the VERY bottom of this page, click on the VBA INSIGHTS sitemap link for tons of other helpful information.
Comment