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
|
|||
|
|||
Selecting records on sub form
I have a multiform screen,(my first!) comprised of two tables with a
master (client) /detail relationship, connected by a field called LastName ... its a one to many relationship .. so when I key in a clients name on the top half of the form all the relevant transactions from the detail table show on the bottom. I have created a command button on the detail subform and now I want to extract all the detail lines from the subform, for a particular Client (where the focus is) & feed tem into a query for subsequent processing when I click on the command button. Any help would be much appreciated. abay |
#2
|
|||
|
|||
You wouldn't actually take the records from the subform. Instead, what you
would do in the query is provide it the same parameters that are being used by the subform so that you come up with the same results. Remember to include the Parent/Child link field in these parameters because that is also filtering the subform, not just the parameters in the subform's query. -- Wayne Morgan MS Access MVP "Abay" wrote in message ... I have a multiform screen,(my first!) comprised of two tables with a master (client) /detail relationship, connected by a field called LastName .. its a one to many relationship .. so when I key in a clients name on the top half of the form all the relevant transactions from the detail table show on the bottom. I have created a command button on the detail subform and now I want to extract all the detail lines from the subform, for a particular Client (where the focus is) & feed tem into a query for subsequent processing when I click on the command button. Any help would be much appreciated. abay |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need query to separate 2 entry types in a table field | Jan Il | Running & Setting Up Queries | 31 | November 23rd, 2004 05:57 PM |
SELECTING RECORDS FROM FORM ADD MODE | albertsong | Running & Setting Up Queries | 4 | November 18th, 2004 09:49 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
Searching Records | Melissa Lambino | New Users | 6 | July 20th, 2004 04:51 AM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |