re print buttons not picking up newly entered form details
Thanks for ur reply to my message.sorry about that.
I have a form with a print button it and when I print the form which opens a report it does not pick up the newly entered detaisl.
Below is my earlier post that explains the proble better:
I have a form with a print button which is the code below attached to the button. I have saved this same form as a report so when I click on the print button it opens open the report to Print.
However I have noticed that if I add new details(record ) into the form and click the print button, the page to print is blank , it does not pick up the newly entered details even when I press the save button.
Also I noticed that when I click the print button after closing the form and opening again some details show but the calculated fields that are (calculated on fly) the fields are not in the table do not show up (totalpounds and total naira).
Also noticed that the buttons are showing even though I have selected display on screen only.
Private Sub Command105_Click()
If Me.Dirty = True Then Me.Dirty = False
Dim strDocName As String
Dim strWhere As String
strDocName = "R-Transaction Add New Record"
strWhere = "[TransactionNumber]=" & Me!TransactionNumber
DoCmd.OpenReport strDocName, acPreview, , strWhere
Can some pls help me, how can I solve this problem or am I missing something crucial
Many Many Thanks for ur help. I downloaded ur reply to digest it and it did solve the problem and add to my understanding.
just wandering do u think creating the 2nd form would be better from scratch as I noticed from the print out that it was picking up fields from the first form, hence not showing its own cal , eg its comm amount hence total is wrong?
I based the 2nd on the 1st u see (I saved it.) This way (i mean new form even though i rather not- time wise) I can then save the form as a report based on the newly created form(2)
Any suggestion pls?
Many Many thanks for helping me solve this problem. Much appreciated.
Viewing that SQL statement in the query design screen will probably help you to see it better. Basically, the 'Right Join' means "I want to see all records from tblTransactions, and if there are corresponding records in tblBank and tblRange...show me those too"
As far as your question goes (if I understand correctly), I would base my decision on how much time you care to invest. Experience tells me that sooner or later you would probably be re-doing the 2nd report. The 2nd form seems to be fine. Nothing wrong with copy/paste/modify if it saves you time. No sense re-inventing the wheel.