473,473 Members | 2,319 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

controlsource

lee123
556 Contributor
hey all, i have a question i have a field on a form called (matlogo) ok and i have added another field that is unbound (textbox control) and i tried to input in the controlsource a iif code something like this:

Expand|Select|Wrap|Line Numbers
  1. =iif([matlogo]=[somename],"thursday")
but when i execute this code it just says name# weird huh? because when i change the code to another field in the form like this:

Expand|Select|Wrap|Line Numbers
  1. =iif([routenumber]=32,"steve")
then it displays "steve"

why does it do this for the second code and not the first one.

lee123
Oct 14 '07 #1
5 1385
MMcCarthy
14,534 Recognized Expert Moderator MVP
Hi Lee

Is [somename] also a bound textbox on the form? If it is check the Name property of the textbox. It may not actually be [somename]

Mary
Oct 14 '07 #2
lee123
556 Contributor
well actually the form it self has a search on it and when i search for a name of a mat it displays in the textbox (matlogo) so the textbox (matlogo) is bounded:

Expand|Select|Wrap|Line Numbers
  1. =iif([matlogo]=[texas roadhouse],"thursday")
to answer your question [somename] is a name of a mat
i think i answered your question.

lee123
Oct 14 '07 #3
MMcCarthy
14,534 Recognized Expert Moderator MVP
Try this ...

Expand|Select|Wrap|Line Numbers
  1. =iif([matlogo]="texas roadhouse","thursday")
Oct 14 '07 #4
lee123
556 Contributor
thanks mmccarthy, that worked you know it's funny you have to put quotes around it when all of the others you don't. why is that?

lee123

good to hear from you i haven't seen you lately thanks.
Oct 14 '07 #5
MMcCarthy
14,534 Recognized Expert Moderator MVP
thanks mmccarthy, that worked you know it's funny you have to put quotes around it when all of the others you don't. why is that?

lee123

good to hear from you i haven't seen you lately thanks.
Number values don't need quotes but string or text values do.
Oct 14 '07 #6

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

Similar topics

3
by: Shelli Carol | last post by:
Good day, I have: 1) A table with numbered fields (1, 2, 3, etc.) 2) A form text box, whose ControlSource property contains an expression. This expression returns a number. If I just...
4
by: Steve Jorgensen | last post by:
Hi all, This is actually not an issue of mine, but one a friend of mine told me about that I was able to confirm. Let's say you want a highly customizable report, so you want to be able to do...
0
by: Paul T. RONG | last post by:
Hello there, there is a text box txt0, its controlsource is =( & ", " & ) it works in one mdb, but not in another. Where is the problem? please help. Paul
3
by: Otie | last post by:
Is there a simple answer as to why my database will not save the data that correctly appears in the AccountID textbox on a form to the table when I set the AccountID.ControlSource =...
1
by: Mexar | last post by:
My programming grammar might be a little off but I have a pretty good idea of what I need to convey. I am making an Access database with a form that pops up and lets you choose to select an...
3
by: Michael R | last post by:
Hello. I need a help to solve the following: I'm intersted in having the Control Source of a textbox as following: ="Comment, " & When I input this from Design View into the Control...
2
by: brnkstyle | last post by:
I want to change the controlsource of a textbox when i click a command button but everytime i do so it gives me #Name$ in the text boxt this is what i want to control source to be ...
13
by: ringer | last post by:
Hi, I have a text box on report where I need to have dsum return a total. The records I need the total from are not in the table that is the report's recordsource, and to complicate things...
0
by: =?Utf-8?B?Q2hyaXN0aWFuIEJhaG5zZW4=?= | last post by:
Is it possible to bind a data access page textbox controlsource property at run time? I've tried using the BeforeInitialBind event to set the controlsource for textboxes, using syntax like ...
14
by: OldBirdman | last post by:
I have a textbox on a continuous form that I want to display a calculated value. I have set the ControlSource Property = & "~" & . I would like to have my user be able to correct this value, and...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
1
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.