Click 1 form to load data on another form

[nono5551212]

I was hoping someone could show me how to load a record on a form..

I only have one table that both forms pull from.

I have 3 forms. The only form a user will ever see is F_Main

F_MAIN (Just loads the 2 forms below within itself)
F_Data_Short (Grid View.. Rows and Columns.. All Records.. Shows some fields)
F_Data_Long (Single Record View.. Showing all fields)

F_MAIN
-> On the left is F_DATA_SHORT
-> On the Right is F_DATA_LONG

How can I set it.. When a record on the left included form is clicked.. it loads that same record on the right included form. No pop ups...



I know I can use the On Click option for the form on the Left... and set code or a macro to the load the data on the right. I tried everything and can't seem to get the data to load on the right when a record is clicked on the left...

Thanks for taking the time to read my post.

[ItsMe]

Data is not stored in forms. Data is stored in tables. You only have one table. Use bound controls in the first form to populate fields in your tale. Use bound controls on another form to display the data stored in the table. Use the .Requery Method of your form(s) to "see" the most current data in the table.

[nono5551212]

I figured it out.

MACRO
BROWSETO
Object Type: Form
Object Name: Your_Form
Path to Subform Control: Your_Main_Form.Your_Form
Where Condition: =="[ID]=" & [ID]
Page:
Data Mode: Edit

Also you should prefix the Macro
If IsNull([ID]) Then
Stop Macro
End If