how to get text from box in report

B

Brent

I am writing a visual basic program that calcualtes fields based on
two fields in a report. The report needs to be opened first. how do
I pull data from a text box? I tried using var1 = [text1].text
but VB says I need to set focus to it first. [text1].setfocus isn't
allowed in reports that are open. Please help.


Brent Scrivner
 
E

ET Sherman

var1 = Reports!YourReportName!YourTextBoxName

OR

var1 = me.YourTextBoxName

Regards,

ET Sherman
 

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

Link a text box based on drop down box with four options MS Word 365 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Change text box background color depending on value in Label Reports 0
OpenForm Criteria in Access 2007 12
Report Shows ID instead of Text 4
Report Totals on Text Boxes in Sub Report 2
Summary Report 3
Access 2007,reports,VBA 2

Top