Form navigation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form that displays all the data that I have in the other forms
in the database. What I want to do is when I am looking at the main form is
to be able to click on a command button and go to one of the other forms in
the database that displays the current information shown on the main page.
For example: the main page is split into 4 sections: 1. Case details 2.
Personal details 3. Vehicle details 4. Telephone details. I have 4 forms in
the database named the same with all the same information from the main page.
I want be able to open the other forms from the main page, each section
seperately displaying the information currently displayed on the main page.
Please help
 
Good afternoon

The following general statements will allow you to open any other form based on
the RecordID.

Simply substitute the form name and the ID with the appropriate values


Private Sub RecordID_Click()

DoCmd.OpenForm "frmDetails", _
WhereCondition:="RecordID=" & Me.RecordID

End Sub


Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
Back
Top