on click rpt opens unless Access is hidden

  • Thread starter kathrynwoning via AccessMonster.com
  • Start date
K

kathrynwoning via AccessMonster.com

I am having trouble displaying a report from a button on a form.

Here is the scenario: When I click on the DB file my code hides Access. (Call
DoAccessWindow(0)) This leaves only a small form open (frmStartup) which
gives 5 button options to the user. When you click "Manage Architects" a form
displays that allows data entry or search options on tblArchitects. On this
form (frmArchitects) there is a button that displays a report listing all
the bids we have associated with the selected architect. When I am working on
the Database (it is not hidden) all these buttons function properly. This
report displays correctly On Click. However, when the end user tries to open
this report (having begun from my startup form) the program hangs. I have to
go to End Process in order to get out of Access.

Can anyone advise me about the conflict here? At first I had thought the
issue rested with pop up and modal properties, but now I am not so sure.
Incidentally both are set to yes on each form, as well as the report.
Changing those settings on the two forms causes them not to display at all.
 

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

Top