Designating the current form for DoCmd.ShowAllRecords
When invoking DoCmd.ShowAllRecords, how does MS Access 2007 designate the current form?
I want to build a form dialog box for searching for a record in another form.
This link explains how to use a Microsoft Access Combo Box to search for a record.
http://www.databasedev.co.uk/combo_box_search.html
IMHO, this solution assumes the combo box is on the form to be searched. I would like to put the combox box on another form, a form dialog box. The problem lies in this command:
DoCmd.ShowAllRecords
Based on the definition of the ShowAllRecords method, ...
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx
the method is applied to the current table, query, or form. So, if a subroutine invokes this method for a form that doesn't have a table, it isn't clear how MS Access 2007 would designate the current form :confused: .
Why not put the combo box on the form to be searched? IMHO, the collection of search fields takes up too much real estate on the form.