Interactive SubForms

[SteelFire via AccessMonster.com]

I have a form and in it is a subform that is a list of the records that come
up in the text boxes on the form.They both show the same record set. It is
just a kind of list to show the data while the text boxes allow for editing
and ease of reading the records. Is there a way so that if I click on a
record in the subform that it will bring up that record in the text boxes?

 

[Jeanette Cunningham]

Hi SteelFire,
have a look at what Allen Browne has to say about how to filter based on a
record on a subform.
http://allenbrowne.com/ser-28.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[SteelFire via AccessMonster.com]

Thank you so much. I was told of that site a little time ago, but at the time
was also directed to another that fixed the problem at hand, so I didn't look
into this one. This is just what I needed. I might just go through and read
all of the tips. Ps. This is so much better then fontstuff.com.

Hi SteelFire,
have a look at what Allen Browne has to say about how to filter based on a
record on a subform.
http://allenbrowne.com/ser-28.html

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

I have a form and in it is a subform that is a list of the records that
come

[quoted text clipped - 3 lines]

and ease of reading the records. Is there a way so that if I click on a
record in the subform that it will bring up that record in the text boxes?

 

[Jeanette Cunningham]

Glad you liked it - Allen is well recognised for his website.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Thank you so much. I was told of that site a little time ago, but at the
time
was also directed to another that fixed the problem at hand, so I didn't
look
into this one. This is just what I needed. I might just go through and
read
all of the tips. Ps. This is so much better then fontstuff.com.

Hi SteelFire,
have a look at what Allen Browne has to say about how to filter based on a
record on a subform.
http://allenbrowne.com/ser-28.html

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

I have a form and in it is a subform that is a list of the records that
come

[quoted text clipped - 3 lines]

and ease of reading the records. Is there a way so that if I click on a
record in the subform that it will bring up that record in the text
boxes?