using one form as an index, and linking/passing record to another form (1 Viewer)

D

DCorvec

Guest
I was wondering if anyone had any easy suggestions for the problem I am currently facing.

I am writing a relatively simple DB in Access2k and would like one of my forms to act as an index, showing certain fields from a table. The problem is that I can't seem to figure out how to link (Onclick event) one of the records displayed fields to another more detailed form.

Essentially you can look at it like this,
I have a Table of contents for a book, I want the Chapter number to be a clickable object that will take me to the correct chapter (or record)

This DB is completely local, no internet stuff involved, any suggestions anyone can give would be very helpful.

Table1 = 25 fields
Form1(index) = 4 of Table1's 25 fields
Form2(details) = 25 of Table1's 25 fields

I want to pass the key value from key field on Form1 to Key field on Form2
 

Users who are viewing this thread

Top Bottom