change text in label consecutive through VBA

[peterr.]

Hi,



first of all sorry for my bad English
second, I have a question, how can I make my Db that when I choose a number from "MAS" the corresponding
"dl's" (a through k) comes nicely below each other, so when I choose 100 a,b,h,j,k comes emerge.

can someone help me with this ?

http://members.upc.nl/h.vandegouw/voorbeeld.accdb

Gr Peter

[June7]

That would require a UNION query.

The table is not a normalized structure. This design will likely cause you lots of frustration.

Normalize structure and a SELECT query could easily produce the output you want.

[peterr.]

A union query? why, a union query adds 2 table's into 1 isn't? how should I do this?
(my knowledge of acces and sql is not so high)

[June7]

Example:

SELECT ID, 1 AS Source, Field1 AS Data FROM table
UNION SELECT ID, 2, Field2 FROM table
UNION SELECT ID, 3, Field3 FROM table;

[peterr.]

I think this is the intention? but how do I get it included in the label

when I run the query the response is all possible choices in data 0 & -1 is that right?
(see my Db in startpost)

[June7]

I did view your db and commented on it.

Build the UNION query. Must type into SQL View of query builder.

Then use that query as source for subsequent queries or the source for a report.

Data in UNION query cannot be edited.

[peterr.]

Hi,
Sorry, I doesn't understand it what you mean,
In the link in my startpost I have added the query, I don't know how to build it further to add/edit the text automatically

[June7]

The UNION query I offered was an example. You must use your field names. There is no ID field in your table. Use your field names as appropriate. Perhaps replace ID with [MAS nummer].

What is this table for? Why are there fields named a, b, c, d, e, f, g, h, i, j, k and these are also values in the [MAS nummer] field?

[peterr.]

this table is like an configuration table, we have different lists 100 trough 800 and to these lists another lists can be linked together,
list 100 has lists a,b,h,j,k.
my intention is the label name's nicely arranged under each other like in the form hard coded (updated link in start post)

[June7]

Did you edit the query?

[peterr.]

yes I edited it, when I run it stand alone I get an table with the [mas nummer] and 11 sources with -1 to the checked fields, only how can I
translate it to the labels

[June7]

What do you mean by 'translate it to the labels'? Are you trying to print a sheet of labels?

[peterr.]

no I mean the label in the form

[June7]

Why would you want to have data show in label? Use a textbox bound to field.

Why would you want this query on a form? Cannot edit the data. Perhaps you should build a report?