Q
Problem solve Get help with specific problems with your technologies, process and projects.

Setting navigation between different tables in Access

I am developing a VB.NET interface on top of an Access database. I have two tables in Access. Each form is connected to a table. The tables are related in Access by identification number. How can I set the navigation, so that if the user opens Form 1 and is on Record 5 of Access Table 1, when they navigate to Form 2, they are on the same Record in Table 2? I appreciate any feedback. Thank you, greatly!
You can simply pass the ID from the first form to the second, for example, in its constructor, or as a property. The second form, then, can take that value and position its own record. So, Form 1 calling code would be something like the following:
new Form2(currentId).ShowDialog();

Form 2, in turn, adjusts its constructor call to receive the parameter 
and select a subset of the information to display:
 
public class Form2(int id)
{
  //store the ID, filter elements, whatever.

This was last published in April 2004

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchCloudComputing

SearchSoftwareQuality

TheServerSide.com

SearchCloudApplications

Close