Hi guys, I have a main menu with a search button which allows the user to search for a record. This is the parent id which has many child ids connected to it. The user searchs the parent id and then has a form that brings up that id, now the user clicks on another button which runs another query which searches for all the ids associated with the parent id as mentioned before which brings up another form with search results. Now I have the form which works good and brings up all the ids associated with the parent id. Now I put a button and want to open up that form through the search query form. I have GTSR_ID as the parent, TR_Id as child and then revision field in this search form and the button to open up that form. When the user searches the for his/her form they can have multiple same TR_ID's(child id) for the one GTSR_ID(parent id). For example for GTSR_ID, the id is 50, and the TR_ID is 45. however revision will be 0 and there will be another record which GTSR_ID is 50 and TR_ID is 45, but revision is 1, which is another record but same id. I want to open up the form specfilly to the revision field. T
This is the code to open up the form, which is does but not it does not open up to spefic revision which is another record, for example if the user clicks on the 2nd revision, it will open up to 0th(which is the defulat 1st revision for all forms) revision instead of the 2nd revision for the record. What do I do to get it to open up the specific record according to revision. Hope this makes sense!
DoCmd.OpenForm "TR_Form", , , "GTSR_ID = '" & Me.GTSR_ID & "'"