Form with query as record source

[rexb]

I've a form with query as my record source. When my form opens I would like to be able to click on any fields and another form would open having all the data of the particular row of data displayed. Right now what access is showing me when I do this is just an empty form where I am suppose to input data. Can anybody help me. Somebody previously helped me when I was trying it with just tables and not query as source.

Thanks in advance.

 

[ezfriend]

You will need to add the click event (perhaps, double click event) for all of the fields and when any particular field is click (double click), open your second form. You can use the same query for your second form. On your DoCmd.OpenForm, you will need to filter the record using the selected record's record id.

 

[rexb]

You will need to add the click event (perhaps, double click event) for all of the fields and when any particular field is click (double click), open your second form. You can use the same query for your second form. On your DoCmd.OpenForm, you will need to filter the record using the selected record's record id.

I think that is what I have right now. but once the second form is open it doesn't display the records that was clicked(double clicked)