Selecting a record and calling up a separate form

[Phil Matish]

I would like to know if the following is possible:

I have a form and a subform. In the subform, there are records
summarized. (For ex, instead of showing all 19 fields, I only show 3 to
save space.)

I would like the user to be able to select a record in the subform
datasheet, and click a button, or double click, to bring up the ENTIRE
record. (I would have a separate form created for this).

So basically, I want to show a truncated record in the subform. When
the user double clicks or clicks the command button, I want my form to
appear that shows the entire record.

Possible?

Thanks a LOT

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Larry Linson]

That specific functionality is included in the imaging sample databases at
http://accdevel.tripod.com (though it is not the purpose of those samples)
and the continuous forms view form is not in a subform control.

Larry Linson
Microsoft Access MVP

"Phil Matish" <ph****@wesselconsulting.com> wrote in message
news:3f***********************@news.frii.net...

I would like to know if the following is possible:

I have a form and a subform. In the subform, there are records
summarized. (For ex, instead of showing all 19 fields, I only show 3 to
save space.)

I would like the user to be able to select a record in the subform
datasheet, and click a button, or double click, to bring up the ENTIRE
record. (I would have a separate form created for this).

So basically, I want to show a truncated record in the subform. When
the user double clicks or clicks the command button, I want my form to
appear that shows the entire record.

Possible?

Thanks a LOT

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Bob Quintal]

Phil Matish <ph****@wesselconsulting.com> wrote in
news:3f***********************@news.frii.net:

I would like to know if the following is possible:

I have a form and a subform. In the subform, there are
records summarized. (For ex, instead of showing all 19
fields, I only show 3 to save space.)

I would like the user to be able to select a record in the
subform datasheet, and click a button, or double click, to
bring up the ENTIRE record. (I would have a separate form
created for this).

So basically, I want to show a truncated record in the
subform. When the user double clicks or clicks the command
button, I want my form to appear that shows the entire record.

Possible?
Yes, but you cannot put a command button in a datsheet view. Open
the subform in design view, and format the record to look as much
as a datasheet as you want. Then set its .view_as property to
continuous forms. Create the command button using the Wizard, to
open your separate form. Use the "Open form and go to specific
record" option.

If you really insist on datasheet view, you must copy the code
created above to the doubleclick event for each field in the form.
That's a PITA to maintain, and doesnt work for checkbox fields, for
some reason I have yet to discover. Besides it's not as intuitive
as the command button for an inexperienced user.

Bob Q

Thanks a LOT

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!