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

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/AlbertKal...icles/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...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)

"Kim" wrote

> 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

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/O...ibbs,Peter%20S

for some examples.

--
Peter Hibbs


"Kim" wrote:

> 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

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

"Kim" wrote:

> 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