If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Find record on parent form
I have a parent form called "FmLeads". It contains a numeric field
called "ID" It also contains a 3 tab 'Tab Control'. Each tab contains a subform. One of the subforms "FmSalesDispositionAll" is a 'continuous forms' design, on which each record contains a numeric field called "ID". I need code for a 'On Dbl Cick' Event Procedure on the subform's ("FmSalesDispositionAll") ID field. I want the user to be able to double click on one of the ID numbers, which would then find and go to the matching record of the parent form "FmLeads". This record always exists. I'm a new to this and would really appreciate if someone could give me the subroutine code. |
#2
|
|||
|
|||
Find record on parent form
Hi dee,
If you have a main form with subforms, setting the "link parent field" and "link child field" in the form properties will handle this for you. If there is no relationship between the data in the subforms and the parent form, why are they in subforms? Damian. "dee" wrote: I have a parent form called "FmLeads". It contains a numeric field called "ID" It also contains a 3 tab 'Tab Control'. Each tab contains a subform. One of the subforms "FmSalesDispositionAll" is a 'continuous forms' design, on which each record contains a numeric field called "ID". I need code for a 'On Dbl Cick' Event Procedure on the subform's ("FmSalesDispositionAll") ID field. I want the user to be able to double click on one of the ID numbers, which would then find and go to the matching record of the parent form "FmLeads". This record always exists. I'm a new to this and would really appreciate if someone could give me the subroutine code. |
#3
|
|||
|
|||
Find record on parent form
Damian S wrote:
Hi dee, If you have a main form with subforms, setting the "link parent field" and "link child field" in the form properties will handle this for you. If there is no relationship between the data in the subforms and the parent form, why are they in subforms? Damian. "dee" wrote: I have a parent form called "FmLeads". It contains a numeric field called "ID" It also contains a 3 tab 'Tab Control'. Each tab contains a subform. One of the subforms "FmSalesDispositionAll" is a 'continuous forms' design, on which each record contains a numeric field called "ID". I need code for a 'On Dbl Cick' Event Procedure on the subform's ("FmSalesDispositionAll") ID field. I want the user to be able to double click on one of the ID numbers, which would then find and go to the matching record of the parent form "FmLeads". This record always exists. I'm a new to this and would really appreciate if someone could give me the subroutine code. The Parent form only displays one record at a time. The "FmSalesDispositionAll" form contains multiple records where a salesman has quoted, but not sold. The sales manager can then double click the ID number on one of those records of interest to him and see the rest of that record on the parent form above. |
#4
|
|||
|
|||
Find record on parent form
Hi again,
Seems a strange way to go about it, but if it's working for you... Use the recordsetclone functionality like this: me.parent.form.recordsetclone.findfirst ("[ID] = " & me.ID) me.parent.form.recordset.bookmark = me.parent.form.recordsetclone.bookmark Hope this helps. Damian. "dee" wrote: Damian S wrote: Hi dee, If you have a main form with subforms, setting the "link parent field" and "link child field" in the form properties will handle this for you. If there is no relationship between the data in the subforms and the parent form, why are they in subforms? Damian. "dee" wrote: I have a parent form called "FmLeads". It contains a numeric field called "ID" It also contains a 3 tab 'Tab Control'. Each tab contains a subform. One of the subforms "FmSalesDispositionAll" is a 'continuous forms' design, on which each record contains a numeric field called "ID". I need code for a 'On Dbl Cick' Event Procedure on the subform's ("FmSalesDispositionAll") ID field. I want the user to be able to double click on one of the ID numbers, which would then find and go to the matching record of the parent form "FmLeads". This record always exists. I'm a new to this and would really appreciate if someone could give me the subroutine code. The Parent form only displays one record at a time. The "FmSalesDispositionAll" form contains multiple records where a salesman has quoted, but not sold. The sales manager can then double click the ID number on one of those records of interest to him and see the rest of that record on the parent form above. |
Thread Tools | |
Display Modes | |
|
|