Opening a New Form with Assigned Data

  • Thread starter Thread starter L.A. Lawyer
  • Start date Start date
L

L.A. Lawyer

I want to open a form ("MenuForm") and assign a value of a control on the
present form ("CaseID") to different controls (specifically, a ListBox)
called "CaseList". The CaseList is assigned the same CaseID in Column(0).
 
Assumptions:

1. The second form is opened by clicking a command button on the present
one;
2. The bound column of the listbox on the second form is the first one
(CaseID), even though it doesn't show(?);

If both these hold true, thn the code behind the command button should
look something like:

DoCmd.OpenForm "MenuForm"
Forms!MenuForm!CaseList = Me.CaseID

If my assumptions are wrong, post back with details.

HTH,
Nikos
 
Back
Top