473,323 Members | 1,537 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,323 software developers and data experts.

Display table record field in form

135 100+
Hello

I have a table (BOM TOTAL L1 V1) created by a query which only contains one field (TCL1) with ONE record. I've been trying to display this record on a form (either in a textbox or a label) so i can them make some calculations with this number but i CANT!!!

I have tried different things and nothing.

I get error "#Name?" when entering =[BOM TOTAL L1 V1]![TCL1] on the unbounded textbox.

Should the textbox or label be BOUND??? UNBOUND???

Can it be done with any control property or has to be done by code???

Any other possible way arround it?

What im trying to do is to create a form where the user will enter some information (margin %, R&D costs, taxes, etc.) which will be used with the "TCL1" value in order to ger a TOTAL PRICE.

HELP!!!
Sep 13 '07 #1
6 5282
MMcCarthy
14,534 Expert Mod 8TB
Try setting the control souce as follows:

=DLookup("[TCL1]","[BOM TOTAL L1 V1]")Keep the textbox unbound.
Sep 14 '07 #2
Gilberto
135 100+
Try setting the control souce as follows:

=DLookup("[TCL1]","[BOM TOTAL L1 V1]")Keep the textbox unbound.
Thanks it works perfectly.

I just have a last question.

Does "[TCL1]" has to be stored in a TABLE??? (this is actually a make-table query result) can it find the record from just a query? so i dont have to create tables for every single field i need?

Also, can it find the value from a FORM (a calculated field) istead of a table?

Thanks again,
Gilberto
Sep 14 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
No you can use this code on a query. Just substitute the query name for the table name.
Sep 14 '07 #4
as long a the value in the table will not change while you are in the form your working with I would sagest that you set a variable = to a Dlookup like Mary suggested do this in the on open event of the form and then just set the text box equal to the variable. The only resign for this step is so that you only run the Dlookup once; this will keep it from slowing down you app other than that you’re on the right track
Sep 14 '07 #5
Gilberto
135 100+
Perfect. Thank you all for your help
Sep 14 '07 #6
MMcCarthy
14,534 Expert Mod 8TB
Perfect. Thank you all for your help
You're welcome.
Sep 14 '07 #7

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

Similar topics

11
by: bala | last post by:
hi!!! i need to display a disclaimer which is two page in length in a word document. i also need to format the text. the idea is something as follows on opening the application, a form which...
1
by: David | last post by:
Hi, I have a continuous form. For each record I have a field 'HeldDate' (Text Field from a table) Against each record I have a button which sets the visibility of this text box to 'True' and...
9
by: Greg | last post by:
Hi, I have a table with "dates", i'd like to display those dates on a calendar. I've put a calendar in a form, linked to my "date" field, and it works, but only showing one "date" per calendar....
4
by: sparks | last post by:
I am trying to fix a database that someone did about 4 yrs ago in access97. The main table just contains demographics and is on the main form of the database. It has a subform on a tab that...
1
by: Jimmy Stewart | last post by:
Is there a way to set up a combo box so that when the user clicks the arrow, the list is populated with info from a specific field from a table but once they select an option, data from another...
7
by: john | last post by:
In my form I have a master table and a details table linked 1xM. I can search through the whole parent table but I also like to be able to search through the child table fields to find parent...
9
by: wparrott | last post by:
I have a table called tblPayScales. It has 5 fields: numRecID - record ID txtCLASSCODE - a 1 or 2 letter text value (A, B, C, BD, L, LT, etc.) numPAYSTEP - a number value 0-49 numSALARY - a...
1
by: Coll | last post by:
Hi - I'm trying to figure out how to append a record to a table and then open a form and display that record. My thought was to use the autonum primary key field (recordnum) and display the highest...
2
by: banderson | last post by:
Hello, I have a data entry form for a table with information about buildings and am having a problem making a combo box do what I want. I would like to make the combo box show a list of unique bldg...
6
by: Gord | last post by:
I have a report whose Record Source I set in code when clicking on a command button on a form. This Record Source is a table that gets created by the code. I have a textbox on the report whose...
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...
0
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...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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...

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.