Hi,
Looking for help. (Beginner)
Here's what I have and what I'm trying to do...
I have 4 option buttions (A,B,C and D)
I have 4 Combo boxes named A,B,C and D, where the dropdown allows matching numbers 1 to 4.
(Eg If Option B is selected the relevant ComboB is shown/enabled. The dropdown offers B1,B2,B3 or B4)
After selecting the required info. I then click on a "SHOW DATA" button. This will then show the data from the database in a label box (lab1)
The database is a single file but has four tables named A,B C and D, each with 3 columns. (Eg First column in Table C will be the autonumber, the second shows C1,C2,C3 and C4. The third column shows names Eg Alan, Bob, Charlie and David)
So...
As an example I want to see the name asociated with D2
1. I click on Option button D.
2. I select D2 from the dropdown list
3. I click on the "SHOW DATA" button
4. The name in database (Table D, 2nd Col - D2, 3rd Col - Charlie)
5. Result: "Charlie"is shown in Label box
If I then select a completely different option etc and click the button again, then THIS new one is displayed
I've done the code for displaying the info and filled in the database but struggling how to pull the Table, and dropdown info and display it.
Example coding would be much appreciated
Thanks in advance,
Kenny