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
|
|||
|
|||
Drilling Down on a Sub Form access 97
Hi,
Ive created a query which sorts out the records i need. The query returns an abreviated view of the complete record. The results of that query are displayed in a subform in datasheet view. What i want to be able to do is click on one of the abreviated records in the subform and open up another form with the completed record on show. ive created the form which displays the full record but dont know how do sort out the bit that allows me to click on a record in the subform datasheet and automatically open up the form and display the correct record. P.S im a bit of a code novice |
#2
|
|||
|
|||
The domd.OpenForm has an optional argument that takes a where clause.
DoCmd.OpenForm SomeOtherForm, acNormal, , "someID = " & Me.id, acFormEdit, acWindowNormal watch the wrap with above. Notice the fourth arg. Basically you set up a where clause and concat the ID from the partial rec form. The actual word 'Where' is not used. The other following args are also optional and are show for demo only peter walker wrote in message ... Hi, Ive created a query which sorts out the records i need. The query returns an abreviated view of the complete record. The results of that query are displayed in a subform in datasheet view. What i want to be able to do is click on one of the abreviated records in the subform and open up another form with the completed record on show. ive created the form which displays the full record but dont know how do sort out the bit that allows me to click on a record in the subform datasheet and automatically open up the form and display the correct record. P.S im a bit of a code novice |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access Tools Startup Form | John Michael | General Discussion | 3 | September 23rd, 2004 09:42 PM |
Compacting Databases | James C. | General Discussion | 2 | September 15th, 2004 09:59 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |