TEXT box displays field infomation

[ciel220]

Hello,

Would anyone please give me some help on how to display field info. using text box?

I have several tables, wich has a column namely timestamp.

TIMESTAMP
---------
08M02Y
O8M02Y

The timestamp is same across each table.
I have a form and I want to have a textbox or a label showing the timestamp(any one instance of the time stamp).
(Each form is linked to a specific table)

How could I do that? I am using a text box now and I when I bind the text box w/ my field using "control source", I get the #NAME error. What happened? What should I do?

Please help!

Thanks!
ciel

 

[tsumrall]

What do you want the timestamp to do? Normally it's used to record when a record was edited or added. It's only bound to itself (if on a form) and not bound to another field.

 

[ciel220]

All I want is a text box (or a label) displaying data on my form.

I want sth (a control) to display data from a specific field on my table. How coudl I do that?

Thanks in advance!

ciel

 

[tsumrall]

Easiest way

1. Make sure your form's row source points to your table.

2. Click the field list Button and drag the field you want to the form.

if that does't work something else is wrong