Hello, I am new to access and I keep running into a problem. I have created
a form that is based on a query to dispay records in a few fields based on an
entry in a combo box in the form. I have it running smoothly, however when I
assigned the form as a subform in a parent form the query will not run. I
have tried just about everything including designing the subform after the
query itself. What can I do? I am trying to achieve a similar outcome to
the "Order Details" subform in the Northwind sample database.
Thanks!
scubadiver - 27 Sep 2007 15:36 GMT
If the query has a criteria reference in it, it will be wrong now that you
have added an extra layer:
[forms]![form name]![subform name].form![combo name]

Signature
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video
> Hello, I am new to access and I keep running into a problem. I have created
> a form that is based on a query to dispay records in a few fields based on an
[quoted text clipped - 4 lines]
> the "Order Details" subform in the Northwind sample database.
> Thanks!