Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Opening a Report from A Form

Status
Not open for further replies.
92hilux

92hilux

Technical User
Jan 28, 2003
22
CA
I have a report that must be opened via the form.

The report itself works perfectly, asking for a parameter to querry the data with.
The code i presently have.. to open the report, causes it to open empty everytime, regardless of the parameter value.

Is there a simple code that i'm missing?
 
Sort by date Sort by votes
oh one more thing..
How do you transfer a text variable from the form to the report/querry?
 
Upvote 0 Downvote
YEAH!!! i did it!!

only pulled out half my hair!


the code was as follows if you care to know:

>>DoCmd.OpenReport "rptResults", acViewPreview, qryTotal, Title = txtSearchTitle
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
3K
OCM
OCM
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
4K
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
2K
Moss100
Moss100
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
3K
lmcate
lmcate
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
3K
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top