Displaying the records of a MS Access Database

I was wondering if it is possible to show one record based on whether a certain table and a certain table index is selected?

All I need is a little help. Let me clarify my question a little bit. I have a form I designed. Based the user's selection amongst a group of radiobuttons, the program will open a table. Now I want the first textbox to be binded to the key field(ndate) of all the tables. All the tables have the same fields, it is just that the tables have different names. Now with the radiobutton selected and ndate value entered, the user presses a button and the other two textboxes display the other to fields of the table. Now I ask again , is this possible.

So, what you are saying is that each radio button corresponds to one of the tables, and by changing buttons, the user can surf the different tables for the same variable (ndate) which happens to be the index?

Each radiobuttons do correlate to a single table in the database, but they are not binded to anything. I am using a simple IF THEN statement like , IF Radiobutton1.Checked = True THEN...............
You see the form has a label and a textbox the label's text is Date:, so the user would input a date and press the view button. Now what I want it to do from there is like a Sql Select command. I want the other two textboxes to display the other two fields of the selected table. For instance, I input 7/14/05 and press view. I want the record that has 7/14/05 in the ndate column to be displayed showing the other two columns (pk3,pk4) in the corresponding textboxes on the form.

You should be able to use your IF statement to call up a form-- build a form template, change it to use the first table, save as, then change it to second table, save as, etc.

The IF statement would then call up the appropriate form (or query, depending on whether you want to edit or just view) depending on which button is punched.

My apologies for no providing you a script, my VB skills are severely lacking at the moment