I don't know the subject

  • Thread starter Thread starter 1aae
  • Start date Start date
1

1aae

Thank you
I have query this query use unique value for example companyname
CompanyName
Hp
MS
Canon

I want text box in a form display this value like (Hp, MS, Canon) is this possible

thank you
 
Add a column in your query:

AllFields: HP & ", " & MS & ", " & Canon

Then use this field as the recordsource for the text box.


Chris Nebinger
 
Dirk Goldgar
Thank you
This is what I want is Automaticliy concatenated Value in CompanyName Field
without typing and the example is very good
But..Very Hard
Is there any easy code to apply only for one field No Relation just one
Field?
Sorry!
And Thank you

1aae said:
Thank you
I have query this query use unique value for example companyname
CompanyName
Hp
MS
Canon

I want text box in a form display this value like (Hp, MS, Canon) is
this possible

thank you
Click to expand...

If Chris Nebinger's isn't what you want, this code may be:

http://www.mvps.org/access/modules/mdl0004.htm
 
Back
Top