Can't get a subform to pull up information

[Hecronis]

I'm very new to access and I've tried looking on the internet on how to do that but I can't quite find what I'm looking for.

Here's what I have:
A table that hold my client's info [residents]
A form that searches all of the records [search_form]
and 3 forms to enter in the client's information [res_info_1], [res_info_2], and [res_discharge]

The way I have it set up right now I can start typing in [search_form] and it will narrow down the search results in a list box. When I double click the record I want to edit it opens the record in [res_info_1]. What I am trying to do is have a button that will close that form and open that same record in [res_info_2] and then from there be able to open the record in [res_discharge]. Kind of a "next" button, but all I have been able to do is open [res_info_2] and [res_discharge] with a new record or the first record.

I keep thinking that this has to be a lot simpler then I'm trying to make it but I don't really know where to start.

 

[arnelgp]

use the WhereCluase when opening the form:

docmd.OpenForm "rest_info_2",,,"id=Me.ID"

but then again, this is not pleasan to the eyes, closing one form to open another.
what i would suggest is have a Tab control in your form.

 

[Hecronis]

I've never done a Tab control before. That would make things so much easier. How is that done?

 

[Hecronis]

I just go it. thank you that was an awesome idea