User Profile
Collapse
-
It opens the form, but the staff_init box doesnt filter to the selection of the combo box, it stays in blank. -
rakabuku started a topic Using button to look at table before opening new form, otherwise open blank formin AccessUsing button to look at table before opening new form, otherwise open blank form
I'm really new with Acces and VBA, so all the help with code is greatly appreciated!
I created a form that kind of works like a switchboard (FRM_A) with two combo boxes [Organization (cbo_org) and Staff Initials (cbo_staff_init )]. Both boxes take the information from Table_A. This form has a “Search” button. See attached PDF file DB 1.
When I hit the “Search” button it will open a second form (FRM_B). Form FRM_B... -
-
-
When I click on the button it says that the form "TEST 2" does not exist or its misspelled. However that is the actual name of the form. Any idea what could be happening? The snaff_init values come from Table 1.
See attachment on next post.Leave a comment:
-
How to open form based on combo box selection.
I have this form called "switchboar d" and in it are two combo boxes: Organization and Staff Initials (cboOrganizatio n, cboStaff_init). There is also a search button called "OK". See picture "DB1"
What I want to do is, based on the selection of my "Staff Initials" combo box, when I click the "OK" button, I want the Multiple Items Form (Test 2) to open that correspond only to that "Staff...
No activity results to display
Show More
Leave a comment: