By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,572 Members | 964 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,572 IT Pros & Developers. It's quick & easy.

Select Row in Datasheet Subform

P: n/a
I'm resubmitting a question that went unanswered a while ago.
I'll try to rephrase it.

I have a hierarchical form that presents data on an 'organization'.
It has 2 subforms, the first a datasheet view of all the 'members' of
the organization, and the second, detailed information for the
'member' selected in the datasheet subform.

When user selects an organization [w/ yet another form], the resulting
view gives the information on that organization followed by the
datasheet view of members, with the first listed member selected, and
detailed information shown for that member.

I want to give the user the ability to specify which *member* [s]he wants
information about, so that the forms will select that member's
information when displayed. How can I do that?

--thanks, thelma

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 4 Jun 2005 15:47:16 GMT, Thelma Lubkin <th****@alpha2.csd.uwm.edu>
wrote:

Write code similar to this aircode:
dim rs as dao.recordset
set rs=frmOrganization.sfrmMembers.Form.RecordsetClone
rs.FindFirst "MemberID=123"
if not rs.NoMatch then sfrmMembers.Form.Bookmark = rs.Bookmark
set rs = Nothing

-Tom.

I'm resubmitting a question that went unanswered a while ago.
I'll try to rephrase it.

I have a hierarchical form that presents data on an 'organization'.
It has 2 subforms, the first a datasheet view of all the 'members' of
the organization, and the second, detailed information for the
'member' selected in the datasheet subform.

When user selects an organization [w/ yet another form], the resulting
view gives the information on that organization followed by the
datasheet view of members, with the first listed member selected, and
detailed information shown for that member.

I want to give the user the ability to specify which *member* [s]he wants
information about, so that the forms will select that member's
information when displayed. How can I do that?

--thanks, thelma


Nov 13 '05 #2

P: n/a
Tom van Stiphout <no*************@cox.net> wrote:
: On 4 Jun 2005 15:47:16 GMT, Thelma Lubkin <th****@alpha2.csd.uwm.edu>
: wrote:

: Write code similar to this aircode:
: dim rs as dao.recordset
: set rs=frmOrganization.sfrmMembers.Form.RecordsetClone
: rs.FindFirst "MemberID=123"
: if not rs.NoMatch then sfrmMembers.Form.Bookmark = rs.Bookmark
: set rs = Nothing
When I try to use this line [with appropriate names]

: set rs=frmOrganization.sfrmMembers.Form.RecordsetClone

I get a runtime error that the operator must take an object
[I'm sorry, but I'm not at an 'access'ible computer, and I
neglected to write down the actual error text]

I looked at various internet sources and came up with
a similar line that involved use of ! -- again, I don't have my
code in front of me -- and that gave me an 'application or object'
error.

One thing that I do remember: I tried to put the code above [w/ my
requirements--which field, which value, etc -- into
the onOpen subroutine of the main form.

thanks, --thelma
: -Tom.
:>I'm resubmitting a question that went unanswered a while ago.
:>I'll try to rephrase it.
:>
:>I have a hierarchical form that presents data on an 'organization'.
:>It has 2 subforms, the first a datasheet view of all the 'members' of
:>the organization, and the second, detailed information for the
:>'member' selected in the datasheet subform.
:>
:>When user selects an organization [w/ yet another form], the resulting
:>view gives the information on that organization followed by the
:>datasheet view of members, with the first listed member selected, and
:>detailed information shown for that member.
:>
:>I want to give the user the ability to specify which *member* [s]he wants
:>information about, so that the forms will select that member's
:>information when displayed. How can I do that?
:>
:> --thanks, thelma

Nov 13 '05 #3

P: n/a
On 6 Jun 2005 20:13:47 GMT, Thelma Lubkin <th****@alpha2.csd.uwm.edu>
wrote:

Move it to OnLoad. OnOpen may be too early.
-Tom.
Tom van Stiphout <no*************@cox.net> wrote:
: On 4 Jun 2005 15:47:16 GMT, Thelma Lubkin <th****@alpha2.csd.uwm.edu>
: wrote:

: Write code similar to this aircode:
: dim rs as dao.recordset
: set rs=frmOrganization.sfrmMembers.Form.RecordsetClone
: rs.FindFirst "MemberID=123"
: if not rs.NoMatch then sfrmMembers.Form.Bookmark = rs.Bookmark
: set rs = Nothing
When I try to use this line [with appropriate names]

: set rs=frmOrganization.sfrmMembers.Form.RecordsetClone

I get a runtime error that the operator must take an object
[I'm sorry, but I'm not at an 'access'ible computer, and I
neglected to write down the actual error text]

I looked at various internet sources and came up with
a similar line that involved use of ! -- again, I don't have my
code in front of me -- and that gave me an 'application or object'
error.

One thing that I do remember: I tried to put the code above [w/ my
requirements--which field, which value, etc -- into
the onOpen subroutine of the main form.

thanks, --thelma
: -Tom.
:>I'm resubmitting a question that went unanswered a while ago.
:>I'll try to rephrase it.
:>
:>I have a hierarchical form that presents data on an 'organization'.
:>It has 2 subforms, the first a datasheet view of all the 'members' of
:>the organization, and the second, detailed information for the
:>'member' selected in the datasheet subform.
:>
:>When user selects an organization [w/ yet another form], the resulting
:>view gives the information on that organization followed by the
:>datasheet view of members, with the first listed member selected, and
:>detailed information shown for that member.
:>
:>I want to give the user the ability to specify which *member* [s]he wants
:>information about, so that the forms will select that member's
:>information when displayed. How can I do that?
:>
:> --thanks, thelma


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.