I don't know the subject

[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

 

[Chris Nebinger]

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
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

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

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

 

[1aae]

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

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

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

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