Hide and Show Data in a Form

[Muteki]

Hi folks,

I'm pretty much a complete beginner to Access but do have background in RDBMS etc.

Anyway,

I'm working on a database to store Student information as well as Enrollment information etc.
I want to create a form that is populated with the students enrollment information. Original I just used a continuous form and it would show full details for each enrollment that existed for the student.

However, what I want to do is just have a single row for each enrollment then, once clicked (or even a hide / show button) expand to show the full details.

I have something working using the visible functions but the page looks very sparse because of the invisible controls.

Is there a way to get to the page to expand and minimize as the controls are shown and hidden.

I had tried using the footer but this makes it only good for a single record.

Thanks

 

[dbDamo]

Create a form that displays your information in Datasheet view. You can then place some code in the OnClick event of any controls you wish that will then open your continous form and display all information for the selected record by setting the link criteria.