Opening form with preselected record.

[Prysson]

Assume the following

frmTrainingSystem
tblTrainingSystem
frmEditTrainingSystem
cmdEditTrainingSystem
lstTrainingSystem


frmTrainingSystem has as its source tblTrainingSystem it also has a list box in it (lstTrainingSystem) which lists all of the available training systems from the table.

There is an after update event associated with the lstTrainingSystem which selects the appropriate entry depending on what is selected (highlighted) in the list box.

There is an edit button (cmdEditTrainingSystem) which opens a pop-up form (frmEditTrainingSystem).

The frmEditTrainingSystem has a single field in it which I would like to be:

A. Associated with the tblTrainingSystems and
B. populated with the record selected in the lstTrainingSystem.

How do I do that...open a new form with a record entry that I selected from a list on a seperate form?

 

[Prysson]

You probably think I am an idiot but I am fairly new to access...could you give an example of how that statement might look...