viewing multiple records

[CD Tom]

In my app I keep track of a patients RX information. When editing an order
you have the option to view the RX's associated with that patient. If the
patient has 3 orders say order 100, 175, and 250 each order has a RX
associated with it. The user wants to view the rx for that order (which
isn't a problem) I just set the criteria to account and ordernumber, once the
user has the RX form on the screen they want to be able to scroll to the
other rx information, since I'm calling the rx up with the criteria account
and ordernumber only the rx for the given order will show. I would like to
put a button on the rx form that would say View another RX and let the user
scroll through all the rx's. I have a couple of ideas but would like to get
some expert opions. Thanks for any help.

 

[Access101]

If I understnad you correctly, I actually might use this method.

Parent form = Patient
Child_form_1 = Orders
Child_form_2 = Px

Both child forms are placed on the parent form. NOT Child2 inside of Child1.

I also place a text box on the Parent form named ORDERID, which after
testing can be made hidden, but contains the ID from Orders, so that Px can
refer to it.

Enter this in the control source of that text box: =sfrmOrders.Form!OrderID

In the Properties of the PX subform, enter this:
Link child Fields = OrderID (this refers to the text box you created and
named OrderID)
Link Parent Fields = OrderID (this refers to the FK on the PX subform)

Now, when you select Order 1 in the Orders SubForm, it will show the
corresponding 3 prescriptions in the PX subform. When you select Order 2, it
will show the 10 corresponding prescriptions in the PX form.

Does this make sense?