At the top of the form I have "Report ID" which is the primary ID number and "Linked ID #" which is the ID number of the '2nd page' if there is a second page. This form is a split form so the user can click on any piece of data in the table at the bottom. I have 2 labels at the top of the page, one says "Page 1" one says "Page 2" this is there if there are more than 1 page. I'm trying to get it so if the Report ID Value is less than the Linked ID Value then "Page 1" would be visible and vice versa for "Page 2". For the 1st page the Report ID will always be less than the Linked ID # and the 2nd page will always be the other way around. The code is:
- If Me.Report_ID.Value < Me.LinkID.Value Then
-
Me.Page1.Visible = True
-
End If
-
If Me.Report_ID > Me.LinkID.Value Then
-
Me.Page2.Visible = True
-
End If
Since this form doesn't open or close or reset I'm not quite sure how to execute this idea. I have pasted it in after update, on focus, data change, data set change of the form as well as the report Id object. I can not for the life of me figure it out. I'm still learning VBA so any input to point me in the right direction would be greatly appreciated.