Text boxes in MS Access

[Loubie]

I am trying to create a text box in a subform of one of my databases, and for each entry/name I want to write different things in this text box. How do I programme a text box in Access so that it keeps the details per entry as opposed to updating every entry with the most recently typed text? Any help would be much appreciated?
Thank you.

:confused:

[Winx]

i'm not quite sure i understand what you mean - could you be a bit more specific please? i'm well clued up on access.

[Loubie]

Dear Winx,

Thank you for attempting to answer my question!

I have a large database in Access, which has everything from the Tables included on a main form with sub forms. I want to have a blank text box on one of the sub forms, so that I can add free text to each Individual. I have managed to put a blank text box in the sub form, but when I write details in the sub form belonging to Mr. X (for example) the same free text is copied into every single entrants form, so it is mirrored in the entry for Mr. Y and Miss Z too? Is there any way to have a blank text box that just holds information for one entry as opposed to putting the same text in each entry? Does that make vague sense? I'm so sorry not to be more technically minded!

Thanks again. Loubie :confused:

i'm not quite sure i understand what you mean - could you be a bit more specific please? i'm well clued up on access.

[CaptainD]

Your wording is not very clear, if I uderstand you correctly you want a text box that when you make an entry, it enters that information for everyone.

If so, just have a field in one location that holds that information and do an update for that field.

 UPDATE YourTable SET OneField = Trim(txtMyTextBox.Text) 

[sandra4006]

Hi,

I am having the same problem as Loubie. I am using MS Access 2003 and working in Form mode. Everything is working well until I come t oa particular field and when I enter data it copies through to the same field in all records.

I need to have different data in the field for each record. And, I need to have lots of information/data in each field.

I have tried Unbound and I can enter more data but it spreads throughout the data base.


I have looked closely at another database and have closely copied the properties to no avail.

What am I doing wrong?

Cheers, SANDRA4006

[KelHemp]

I'm by no means an expert, but I think the problem is in your table you're using for the form... in my experience, just creating a text box and writing in it is like stamping the whole form with that information. instead, you need to tell it to see the difference between the records by making a field for it in your table. Then, add the text box, and give it the source of that field.

That help?