Can't create subform base on Pass-through query

  • Thread starter Thread starter Jordan
  • Start date Start date
J

Jordan

I have seen several MS articles that show that you cannot create a linked
subform when the subform is based on a pass-through query. Unfortunately I
need someway to show a datasheet on my form that is basically a list of
orders for the customer. Normally I would just use a linked table for the
Orders and Customers tables and base my subform on the Orders table, but for
some reason I cannot link this table via ODBC so it has to be a
pass-through.

If I can't use a subform to show a data sheet of orders on my form, what
other options are there using Access 2000?
 
Jordan said:
I have seen several MS articles that show that you cannot create a linked
subform when the subform is based on a pass-through query. Unfortunately I
need someway to show a datasheet on my form that is basically a list of
orders for the customer. Normally I would just use a linked table for the
Orders and Customers tables and base my subform on the Orders table, but for
some reason I cannot link this table via ODBC so it has to be a
pass-through.

If I can't use a subform to show a data sheet of orders on my form, what
other options are there using Access 2000?
Click to expand...

ListBox?
 
Back
Top