RecordSource Using a PassThrough Query

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a form that I change the record source for using a passthrough query.
This works fine but now I need to be able to bring back more than one record.

Using Code I actually create the Passthrough query and save it the queries
tab, then assign the form fields to the value of each corresponding field in
the query. I want to be able to scroll through each row in the query. I also
want to leave the form fields unbound because I need to use these fields to
run another pass through query that updates the back end database.

Any ideas is much appreciated

Thanks

-Chris
 
Chris said:
I have a form that I change the record source for using a passthrough
query.
This works fine but now I need to be able to bring back more than one
record.

Using Code I actually create the Passthrough query and save it the queries
tab, then assign the form fields to the value of each corresponding field
in
the query. I want to be able to scroll through each row in the query. I
also
want to leave the form fields unbound because I need to use these fields
to
run another pass through query that updates the back end database.

Any ideas is much appreciated
Click to expand...


I'm not sure I follow you, but you can have a bound form with unbound
controls. In that case, the normal record-navigation buttons will work (or
you can build your own, which would manipulate the form's recordset), but
you have to use code in the form's Current event to load up the unbound
controls from the corresponding fields.
 
Back
Top