Continuous form with ability to show record details

[Guest]

Even as I type this I'm sure there is an easy way to do this but I'm drawing
a blank, please help . I would like to display a continous form showing
all projects we have running (should show just one field at the tope of the
page which is project name). When I highlight one project (one record), i
would like the details of that record to show at the bottom of the screen. I
know I can't use a subform with a continuous form so am I jsut going about
this the completely wrong way? Any help would be appreciated, and thanks in
advance

Kim

 

[Albert D. Kallal]

Actually, try two *sub* forms side by side.

The very last screen shot, and the very first screen shot gives and idea of
what you might want:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

Note that the very *last* screen shot has TWO continues forms, but the form
on the right side could VERY well have been a SINGLE form that displays the
details of the record selected on the left side...

 

[Larry Linson]

Even as I type this I'm sure there is an easy way to do this but I'm
drawing
a blank, please help . I would like to display a continous form showing
all projects we have running (should show just one field at the tope of
the
page which is project name). When I highlight one project (one record), i
would like the details of that record to show at the bottom of the screen.
I
know I can't use a subform with a continuous form so am I jsut going about
this the completely wrong way? Any help would be appreciated, and thanks
in
advance

If you could be satisfied with a multi-column Combo Box, the Combo Box
Wizard will build for you the functionality you describe. Alternatively,
you could use a Subform Control with a continuous forms view Form embedded,
and respond to a Click event on a Command Button or DoubleClick on any Field
in the Record... then use the ID field selected to locate a record, either
on the main Form or in another Subform.

When I've done something similar in the past, I've just had a continuous
forms view Form, and left it open in the background, and opened a new
(detail) Form to the proper record using DoCmd.OpenForm with a
WhereCondition. When I close the detail Form, the selection Form is again
visible. That's not quite the selection-at-the-top,
detail-at-the-bottom-of-the-same-page arrangement you describe, but
workable.

Larry Linson
Microsoft Access MVP

 

[Guest]

You could use a Flex Grid control to give you the most flexibility. Have a
look at my Flex Grid demo program at -

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S

for some examples.

 

[Guest]

Thanks for the responses, all good ideas and the help I needed!