Help with Form based upon Recordset

[Lurch]

Hi there;

I have a continuous form (I inherited this thing) that returns data based
upon some vba coding using the recordset and then a SELECT query right in
the code. How can I click on a field in this continuous form so that another
form pops up with the detail of the field/record that I just clicked.

Let's say I have tblContinuous with Field1, field2, field3, etc...

I click on Field1 - This is a Location Code. Now I want to bring up a form
that will be based upon another query but uses the data from Field1 as a
kind of filter so that I only see that Location Code I just selected.

Any help would be great. Thanks!!!

Lurch

 

[Rick Brandt]

Hi there;

I have a continuous form (I inherited this thing) that returns data based
upon some vba coding using the recordset and then a SELECT query right in
the code. How can I click on a field in this continuous form so that another
form pops up with the detail of the field/record that I just clicked.

Let's say I have tblContinuous with Field1, field2, field3, etc...

I click on Field1 - This is a Location Code. Now I want to bring up a form
that will be based upon another query but uses the data from Field1 as a
kind of filter so that I only see that Location Code I just selected.

Any help would be great. Thanks!!!

The command button wizard has an option that does exactly what you want.