Using subform records to select mainform record

[sal]

I have a main form which allows for the viewing and entry of individual survey information and a subform which shows all the surveys for the location of that survey. These are linked by the location field but also share the survey# field.

There may be times when one would need to navigate to an individual survey on the main form by clicking on the survey data in from the subform.

Can this be done?

 

[Trevor G]

All of your records in the sub form are like a datasheet are they or a single form view? If single form view this maybe able to work, if in a datasheet view this maybe a little more difficult.

You would need to establish which fields are being used as the link and then within the subform you would need to use an on click event if the field is a text box if using a combo it will be on after update (I think)

On click event you could use a macro/vba to open the (Form record) so it would have criteria that perhaps would work along the lines of OpenFrom then name and then in the criteria ID from the table = the id in the subform

You might also be better of uploading a sample of your database so some one can take a look.