dwcrockford
New Member
- Joined
- Sep 1, 2015
- Messages
- 27
I am trying to design a button (on a Dashboard Form), that will open a specific record in another form.
So, I need the button to Open the form, search specific term(number in this case), in a specific field (ID - indexed, no dups).
So by clicking on the button on the "dashboard", a message will pop up to enter the criteria to be searched for, and when that is completed (and ok or enter is pressed), the associated form will search for and open a single record that matches the criteria.
The associated table name is "Work Order", and the field in which I want to search is "WONumber".
I know the combo box version, however that would need to be on the Work Order form, not on the external Dashboard (named "ServiceCalls")
Am I asking too much of Access?
So, I need the button to Open the form, search specific term(number in this case), in a specific field (ID - indexed, no dups).
So by clicking on the button on the "dashboard", a message will pop up to enter the criteria to be searched for, and when that is completed (and ok or enter is pressed), the associated form will search for and open a single record that matches the criteria.
The associated table name is "Work Order", and the field in which I want to search is "WONumber".
I know the combo box version, however that would need to be on the Work Order form, not on the external Dashboard (named "ServiceCalls")
Am I asking too much of Access?