I am new to MS Access and currently using Access 2007.

I have copied the "Goto" combo box from the student template provided by Microsoft, but have fail to implement it in my own form.

I have attached a sample of what I am trying to do but failed.



On the access file, there is a "open" field on a form that opens another form used to input data. The problem comes in when I try to use the "Goto" combo box to find other records already in the table. I can use the drop down to see the other records, but when I click on the record, the form does not bring up the record. The form simply stays on the same record. I hope someone here can alleviate my problems.