473,322 Members | 1,778 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Insert a value from a text box into a report

I am having trouble coming up with how to take a unbound value from a text box from another form and having it show up in a report. I have tried many things with no success

The form I am looking up information from is "fmestimate"
Text Box Name is "txtestimatetotal"
Text Box Control is "=CDbl(nz([txtproductlaborcosttotal],0))+CDbl(nz([txtsalescommission],0))

The above gives me the estimate total

I then want to be able to print a estimate page with the total.

Can anyone please help me work this out?

Thanks
Gary
Apr 27 '08 #1
5 1942
Delerna
1,134 Expert 1GB
In the "Control Source" property of the control on the report that you want to access the control on the form do this.

Expand|Select|Wrap|Line Numbers
  1. = Forms![fmestimate]![txtestimatetotal] 
  2.  
fmestimate will, of course, need to be open before you open the report or it won't work.
If the form is not open you will see "#Name?" in the control on the report.
Apr 27 '08 #2
Thanks for your help
worked like a charm.
Cheers!
Apr 28 '08 #3
Delerna,
I just found a small bump - it is not bound to the "EstimateID"
However it does show up perfect on the report form with no error.

i tired to insert at the end =Forms!fmestimate!txtestimatetotal!estimateID
of course has an error.

Thanks
Gary
Apr 28 '08 #4
Delerna
1,134 Expert 1GB
When you say "it is not bound to the estimateID"
What do you mean? Can you clarify that statment.
And how, exactly, does EstimateID come into it.

Regards
Apr 28 '08 #5
When you say "it is not bound to the estimateID"
What do you mean? Can you clarify that statment.
And how, exactly, does EstimateID come into it.

Regards
I can clarify pretty simple. don't know what i was thinking about asking that question. just working on the computer for 2 long at a time and had a brain freeze.
thanks for your help - works great.
Apr 28 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: lea | last post by:
I have two combobox, I let the user to select report criteria FROM xx TO xx. i have a button call btnPrint to select report criteria and print according to the criteria. I able to SELECT the...
7
by: rickcheney | last post by:
I just changed my Access 2002 database to a SQL Server ADP project. I had a form where the user entered a value into a text box and when a command button on the form was clicked a Report was...
2
by: TadPole | last post by:
Hi all, My main problems are::::::::: 1. Set a value within a block container that can be used and changed by subsequent templates/block-containers/tables etc.. 2. get/determine/find the...
9
by: khan | last post by:
on sale report I want to make a check if customer doesnot pay full amount then his dues go in to his account recieveable table. I am trying this in vba and when I complie it on RunSQL it gives me...
1
by: nicholas | last post by:
To insert a record in a Ms Access database and be able to retrieve the newly created ID (autonumber) I used the code below (code 1). Now, the problem is that this is not very secure and that, if...
6
by: SandySears | last post by:
I am trying to use a stored procedure to insert a record using VS 2005, VB and SQL Server Express. The code runs without errors or exceptions, and returns the new identifer in the output...
0
by: Arnold | last post by:
Hi Everyone; In a report, I've essentially recreated a paper sheet by adding various labels--name, date, problem, year, Progress Notes, etc.--and horizontal lines (people have traditionally...
0
ak1dnar
by: ak1dnar | last post by:
There is a Error getting while i am entering records using this jsp file. <%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %> <%@ include...
2
by: wizardry | last post by:
hello - i'm trying to insert a blob into my table, it will insert but the string that i insert when i query the inserted data returns null with 0 bytes in the column. I have other tables set...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.