I've created a form, based on a query, where the form has input fields which determine the criteria for the query to display. The problem is when the form is initially opened, prior to entering the search criteria in the input fields, the last record of the table which the query is based on is visible on the form. I would like to have no records visible until the criteria is entered into the input fields and the query is ran? Any help is appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Hide the last record in a Form used for searching?
- Thread starter revheim
- Start date
Well then make the form NOT bound to your query
Delete the record source
then use this code to set the form to your search
dim MyRecordSource as atring
' Initialize SELECT statement.
MyRecordSource = "SELECT * FROM [YourTable] WHERE [yourfield] = " & Me![Yourtextbox]
' set record source to Subform
'Me![YOURsubform].Form.RecordSource = MyRecordSource
' Set it to a main form
me.RecordSource = MyRecordSource
DougP, MCP
dposton@universal1.com
Ask me how Bar-codes can help you be more productive.
Delete the record source
then use this code to set the form to your search
dim MyRecordSource as atring
' Initialize SELECT statement.
MyRecordSource = "SELECT * FROM [YourTable] WHERE [yourfield] = " & Me![Yourtextbox]
' set record source to Subform
'Me![YOURsubform].Form.RecordSource = MyRecordSource
' Set it to a main form
me.RecordSource = MyRecordSource
DougP, MCP
dposton@universal1.com
Ask me how Bar-codes can help you be more productive.
- Status
Similar threads
- Locked
- Question
