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 3 15925
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: codemonkey |
last post by:
TIA! I would like to know if there is a way to dynamically change the
colors of Subform items? I have already set in place Conditional
Formatting so each row has an alernating color scheme, but...
|
by: A Clark |
last post by:
I have a subform that displays a datasheet. There are a couple of
different queries that can be displayed in the datasheet. The queries
are available in a combo box on the main form. The problem...
|
by: Michael R |
last post by:
Hello to all.
In what way can I update a certain selected records' values on a datasheet subform using a command button which is located on the main form?
Thanks and cheers.
|
by: anthopper |
last post by:
hello-i am a new access user--access 2003 winXP pro.
I am trying to create a form with a subform that will allow me to navigate though all of the records from a single table.
From a formatting...
|
by: paulw4 |
last post by:
I have a mail form that has a datasheet subform, there can be up to sixty items in the datasheet. The data sheet has three fields: AttID, AttName, AttYN
The object is for the enduser to select...
| |
by: WPW07 |
last post by:
Hello Everyone,
I stumbled onto something interesting and was wondering if anyone
else has experienced it and how they fixed it. I've posted to several
forums to no avail.
I've got a...
|
by: WyvsEyeView |
last post by:
I am doing the very standard thing of filtering the contents of one combo box based on another combo box. I've done it many times, but always on a main form. Now I'm trying to do it on a datasheet...
|
by: pzh20 |
last post by:
I have an unbound form/subform where I populate a combo box on the main form, and using the onchange event, display fields from a table in a datasheet subform.
I want to add a new record via the...
|
by: MayoM |
last post by:
Access 2003 has suddenly reordered the sequence of columns in a datasheet subform.
Specifically the last column has stayed in place but the others are back to front. There are about 50 columns in...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |