Retaining and using a selected record??

[Alliance]

Anyone:
I am building an application to document EDI events. I have used TABs to organize the application. In one of the Tabs, I let users enter a "query criteria" to then submit this query and get a window with zero to many rows (results) using a read-only continous form. I want the users to "select" a row (record) from the "query results" form to then be able to go to another Tab where another form allows them to modify related data. The trouble I'm having is that I'm not sure how to use the "record selector" from the query results for a new query on another Tab (I need a field and a value to filter (WHERE clause) the last query using the selected record). It would be nice to be able to open the new Tab programatically once the user selects a record from the initial query.
In short: How can you go from selecting a record in a form (query results) to opening a new form within another Tab retaining the selected record's information? <<Hope this not too complicated to read and understand>>.

I appreciate any suggestions.

 

[TPetersonFlorida]

First you can easily switch to different tabs programatically using the tab index of the tab control, if i'm not mistaken. second on the second tab you could create a continuous form and then after the user selects a record from your results form, dynamically create the SQL statement and set the form controls recordsource to that and switch to that tab all at the same time. does that make sense?

 

[Alliance]

Makes sense.

In fact, on the final Tab where the user can maintain the data, there would be 3 continuos forms to deal with 3 tables related to a parent table where the original query came from. I really need to run 3 querys for updating those 3 forms and let the users edit & add data there.

For moving around sounds like I would want to use something like: &quot;Me.NameOfTheFormWithTabs.Pages(index)SetFocus&quot; to move to the result Tab. Correct?

 

[Alliance]

I am actually having trouble referencing the linking key from the record the user selected in the result query...