Labels from table

[Phil]

Hi,

I have a form with 5 text boxes and I want to get the
labels for the text boxes from a table. I created a one
field table with 5 records for the 5 labels. How do I get
these labels to show on my form? I created text boxes but
I don't know how to define the "record source".

Thanks
Phil

 

[Frank Stone]

hi,
you will have to put labels on your form. if you put a
record sorce for the label captions in the text box, all
that will do is bring the captions into the text box. you
might be able to create the labels with the captions from
the table but why. a lot of extra code. and why put the
cations in a table. do they change? if not it would be
better just to create the labels from the toolbox and add
the captions.

 

[Phil]

I still can't figure out the code to do this and don't
know if it is possible. YES the labels can change and I
need a easy way for the user to change them.

Thanks,
Phil