I need my code to link to field names with spaces??

[ChrisHaynes]

Hi, I have a code which links a combo box to fields in a query. It works for all the fields with no spaces between the words. How can I edit the code to work with fields with spaces? I have tried entering brackets but this hasn't worked. Can anyone help??


=DLookUp([Forms]![frm_Software_Home]![Combo160],"qry_totalUsers")


Thanks alot
Chris.

 

[Golom]

Brackets are the ticket

=DLookUp([COLOR=red]"[" & [/color][Forms]![frm_Software_Home]![Combo160][COLOR=red] & "]"[/color],"qry_totalUsers")

 

[ChrisHaynes]

Hi Golom, that makes sense but now I'm getting a 'Type Mismatch' error message??

Any ideas??

 

[FastLearnerIThink]

What is the field name? "frm_Software_Home" or
"frm Software Home"?

if it is the first one, then it should be fine. If it is the second one, then remove the underscores.

Let me know if that works.

-- Fast Learner, I Think

Here's something to think about. How come you never see a headline like 'Psychic Wins Lottery!'? - Jay Leno

 

[ChrisHaynes]

Thanx alot for both of you're help. I have it working now. I had renamed my combo box to 'test' and had not changed the code from 'Combo160'. And the comma's are working perfect for fields with spaces.

Thanx again guys.

Chris

 

[MajP]

or simply
forms("Any Badly Named form").combo160

controls("Control Name")
fields("Field Name")

Second stop naming fields with spaces. This is just bad programming and your begging for problems. To learn how to name properly here is a good link

http://www.mvps.org/access/general/gen0012.htm

To understand why this is bad (as you have already seen)
FAQ700-2190