Requery Question!

B

Bob V

On my form I have the text box [tbPrivateStatementComment] when I add
something in it to be printed it does not update when I click the print
control on the same form, I have tried Me.tbPrivateStatementComment.Requery
on the On Click Of the print Control but does not Requery, What am I doing
Wrong Thanks for any help...Bob
 
B

Bob Quintal

On my form I have the text box [tbPrivateStatementComment]
when I add something in it to be printed it does not update
when I click the print control on the same form, I have tried
Me.tbPrivateStatementComment.Requery on the On Click Of the
print Control but does not Requery, What am I doing Wrong
Thanks for any help...Bob
Click to expand...
If the textbox is bound to a field in the table, it will only be
stored once the record is written back to the table. That occurs
when you close the form, move to a different record, manually save
the record from the menu, or issue the vb statement me.Dirty=False
in the On Click event of your Print button, before printing the
form. Requerying won't help bring up text that hasn't been saved
yet.
 
P

pietlinden

On my form I have the text box [tbPrivateStatementComment] when I add
something in it to be printed it does not update when I click the print
control on the same form, I have tried Me.tbPrivateStatementComment.Requery
on the On Click Of the print Control but does not Requery, What am I doing
Wrong Thanks for any help...Bob
Click to expand...

try refresh or repaint.
 
B

Bob V

Thanks Bob the Me.Dirty worked Great.........Bob

Bob Quintal said:
On my form I have the text box [tbPrivateStatementComment]
when I add something in it to be printed it does not update
when I click the print control on the same form, I have tried
Me.tbPrivateStatementComment.Requery on the On Click Of the
print Control but does not Requery, What am I doing Wrong
Thanks for any help...Bob
Click to expand...
If the textbox is bound to a field in the table, it will only be
stored once the record is written back to the table. That occurs
when you close the form, move to a different record, manually save
the record from the menu, or issue the vb statement me.Dirty=False
in the On Click event of your Print button, before printing the
form. Requerying won't help bring up text that hasn't been saved
yet.
Click to expand...
 
Top