Greetings,
I have a form that collects data through 3 queries;
(A) Search box
(B) Area
(C) Category
I want to use a macro or any other way that you may suggest to make the following possible:
(A) Setfocus to Search box when the form open
(B) If the user uses a key combination like SHIFT+F2 it will auto fill the area cbox
for example:
Shift+F2 = CA
Shift+F3 = NY
Shift+F4 = Rome
Shift+F5 = London
and after applying the key combination set focus to search button
on the other end I have about 10 reports based on the category and the area selection I want the very same search button to generate each one of them according to the relevance of user select in area and category in the form to the report.
is there anyway possible to achieve it?
I have a form that collects data through 3 queries;
(A) Search box
(B) Area
(C) Category
I want to use a macro or any other way that you may suggest to make the following possible:
(A) Setfocus to Search box when the form open
(B) If the user uses a key combination like SHIFT+F2 it will auto fill the area cbox
for example:
Shift+F2 = CA
Shift+F3 = NY
Shift+F4 = Rome
Shift+F5 = London
and after applying the key combination set focus to search button
on the other end I have about 10 reports based on the category and the area selection I want the very same search button to generate each one of them according to the relevance of user select in area and category in the form to the report.
is there anyway possible to achieve it?