Button and form Issues

[rmohebian]

Hello All,
I have a form which has a drop down list of student names and two text boxes which take a start date and end date. I also have a command button. I want this form to open up another form I have created which consists of complete student information and cheque info displayed in a subform to open showing the info for the selected student name and I want the starting date and ending date to reflect the subform. I can use a macro to open up the desired form but I cannot display the selected record. Can someone help me with this,never done any vb coding so pretty new to all this parameter passing?

[dwaterman]

I think you want to link the field they have in common. Try this code to open the form:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "your form name here"

stLinkCriteria = "[your link field name in new form] = " & "'" & Me![your link field in open form] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria