continuous forms from a query

  • Thread starter Thread starter Matt C via AccessMonster.com
  • Start date Start date
M

Matt C via AccessMonster.com

I have a form containing 3 subforms. Each of these subforms is a continuous
form based on a query, in this example, it is for invoices and tells you
which are due today, which are overdue, and which are still outstanding.
Running the query externally reveals one invoice which is outstanding,
however opening the form, will not show this outstanding record in the
appropriate subform. Originally I thought this could be because the query had
to be open for the form to run, but I tried with the query open and still
nothing appears. also, another form I have based on a query, but in for view,
has no trouble getting the data if the query is not open.

any ideas?
 
This is solved now, I had the subform records linked to a field on the
mainform that didn't exsist. I removed the link and the data appears as
expected
 
Back
Top