Dear friends,
I have attached a file with real time details in it.
I want the user to select the accession number from that drop box and then click on one of the three tabs. The results should show only the data of selected accession number.
I added the criteria for the third tab but its not...
Thank you jdraw and khodr.
As per your suggestions I realised that the number of fields are many and has split my master table into three tables of 10 fields each.
I have made a sample database for clarification and wrote 5 queries in it. Now I want the user to give name in runtime parameter...
I have a simple table in excel, converted it into access 2007. The 30 columns in table corresponds to 5 categories. For this table I have designed 5 queries to view each category details individually.
I want to give a dropdown list to the user to choose the category of interest to view...