display report records in access 2007

G

Grimwadec

Mydatabase has frmMain, frmCriteria (called from frmMain), frmList (called
from frmCriteria) & rptMain (which contains subrptMain). All objects (except
subrptMain) are Pop Up and Modal.

The report is based on a query that asks for a numeric ID parameter. I want
both that parameter fed from frmList and rptMain called from frmList but when
I do (noting that both frmMain and frmCriteria remain open) both rptMain and
subrptMain display no records.

However when I feed the parameter from frmMain and call rptMain from frmMain
(noting that frmCriteria and frmList are not open) both rptMain and
subrptMain display the appropriate records.

In desperation I have tried variously changing the Modal setting to "No" to
no avail. Obviously I am missing something. Can anyone please tell me what
the issue is likely to be?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

weird listbox behavior - just upgraded to Access 2007 1
Insert graphic in report 5
PROBLEM - Report based on query that has criteria based on listbox 3
Close form from another form Please help! 2
Need focus on query first, then on Form when query is closed 4
Lookup a value in a table and display text if a value exists 1
Need assistance with secondary axis in Excel 2007 0
Form wont show records 4

Top