want to display specific related record (1 Viewer)

[pbuethe]

I have:

tblCase which has Primary Key CaseID.

tblReview which has Primary Key as CaseID + PCLevel. There may be 1 or 2 records in tblReview per CaseID.

frmCase which is based on tblCase.

frmReview which is based on a query which contains fields from tblCase and tblReview.

frmTDReason, a pop up form based on tblReview.


There are buttons on frmCase to open frmReview and frmTDReason for the current CaseID.
When the buttons are clicked I want the forms to open on the record with PCLevel = "PC1" .
From those forms, I want to then be able to switch to the record with PCLevel = "PC2".
(Not using the record selectors/navigation buttons.)
For example, there could be a combobox to switch between PC1 and PC2.

Thanks for your assistance.

 

[Uncle Gizmo]

Have you considered subforms?

 

[pbuethe]

I solved this using Method 1 here: https://support.microsoft.com/en-us/kb/287658

 

[Uncle Gizmo]

One of the suggested examples mentions the Northwind database,
Extract:-
The Orders form in the Northwind sample database illustrates this method.

Judging by the age of the article I believe they mean the early version which has a fault you should be aware of...

Nifty Access - Northwind Orders Combo Box

And thanks for taking the time and trouble to post your solution...

 

[pbuethe]

I believe I would not have this issue, as I am using the combobox instead of the navigation buttons. I have turned the navigation buttons off.