Good Afternoon
I have just joined access world, because i am in the process of trying to create my own database.
The 2 problems i am having, is I have 2 sub-forms on a form, one called index, one called details.
What i would like to do is as i scroll through the index form, the full data from the table appears on the details form, I just cannot find a way of linking the two to make this happen. (Example attached)
The second problem is, what i would like to do is have a screen with a list of aircraft types, and when i click on a type the above form opens, but filtered just for that type
I hope I am not asking to much, and wonder whether somebody could take a look at my database and correct what i am doing wrong....
Many thanks in advance
Richard
I have just joined access world, because i am in the process of trying to create my own database.
The 2 problems i am having, is I have 2 sub-forms on a form, one called index, one called details.
What i would like to do is as i scroll through the index form, the full data from the table appears on the details form, I just cannot find a way of linking the two to make this happen. (Example attached)
The second problem is, what i would like to do is have a screen with a list of aircraft types, and when i click on a type the above form opens, but filtered just for that type
I hope I am not asking to much, and wonder whether somebody could take a look at my database and correct what i am doing wrong....
Many thanks in advance
Richard