|
-
Jan 26th, 2009, 10:13 AM
#1
Thread Starter
Member
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 .
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|