A
awsmitty
I constructed a search routine for a database. It is a form with a subform
as a datasheet. The form has the search button and a reset button and
various criteria boxes. Everything appears to work fine!
The above was just a test or practice. I am very new to access. Now I
would like to begin the finished product and the above routine would be on
the first tab of a new form. The above search routine doesn't work and I can
not find the proper syntax anywhere to move it to a form with a tab.
Below are two lines from the search routine if that will help any
Me.frmsubAllRouteData.Form.RecordSource = "SELECT * FROM qryAllRouteData " &
BuildFilter
varWhere = varWhere & "[STREET] LIKE """ & Me.txtSTREET & "*"" AND "
I hope someone can help. The ... Me.frmsubAllRouteData.Form.RecordSource
.... I'm sure is incorrect, but I can not find how to code using tabs on a form
awsmitty
as a datasheet. The form has the search button and a reset button and
various criteria boxes. Everything appears to work fine!
The above was just a test or practice. I am very new to access. Now I
would like to begin the finished product and the above routine would be on
the first tab of a new form. The above search routine doesn't work and I can
not find the proper syntax anywhere to move it to a form with a tab.
Below are two lines from the search routine if that will help any
Me.frmsubAllRouteData.Form.RecordSource = "SELECT * FROM qryAllRouteData " &
BuildFilter
varWhere = varWhere & "[STREET] LIKE """ & Me.txtSTREET & "*"" AND "
I hope someone can help. The ... Me.frmsubAllRouteData.Form.RecordSource
.... I'm sure is incorrect, but I can not find how to code using tabs on a form
awsmitty