Text Box with text staying the same in each record

[ScottBeatty]

Hey everyone, I ran into something that I haven't been able to figure out. I have a text box in a form (unbound) and when I go to add text into it, the text carries over from one record to another but I want it to be exclusively for that record. Any help would be greatly appreciated!

Thanks!

 

[jdraw]

What exactly are you trying to do in plain English?
You mention carrying info over from one record to another, but you also say the form is unbound -- I'm confused with how you have implemented something.

 

[ScottBeatty]

Hey thanks for replying! I have a text box that I want to have text in obviously but I want it to only appear for a single record (not in a field or anything, but for the single record in a form of over 1000 records). However, I do want a text box for every record. Hope this helps

 

[rzw0wr]

Not much Scott.
Do you have an UNBOUND text box or an unbound form? An unbound text box will not store data to any table without some code.
If the form is unbound, where are you getting the data?
You mention records. Records are a line of fields from a table.
Fields hold one bit of data. Like a name.
You are also asking for 1000 records. Do you mean fields,Text boxes or records from a table?

Dale

 

[ScottBeatty]

I have an unbound text box. I have about 20 fields per record (one page essentially on the form) but they aren't really that relevant to what I want to do. I was just hoping to have an area on the form that could be used to insert comments by a user. I want to save my database as a template so that multiple users can use it but I want to use a text box as an area to make comments on a "per record" case. I have no intention of adding this text box into the table. I just want it on the form.

 

[jdraw]

If you put comments on a form and NOT in a Table, they will not be stored or saved anywhere. They will exist on the Form only while it is presented on the screen. Once you move off the screen, or to the next record that data is GONE.

Now What in plain English is the purpose of the Comment?

 

[ScottBeatty]

Oh okay I follow that. Is it possible to leave a comment on a record of the form that will stay forever but only on that record? In plain English, it is for management to make any comments about the data presented on the form.

 

[jdraw]

Yes. Depending on your circumstances I'd suggest some of the following might apply.

Create a new Table (since you haven't told us what the Data on the Form represents I'll make an guess --- Tools.) Go with me on this one, we'll get there.
So we have Tool #100 and Manager ABC wants to add a Comment on May 31/2013.

So the new table will have a structure like

tblToolComments

ToolCommentId PK
ToolId FK to the record in the TOOL table
ManagerId FK to the manager's record in the Manager Table
CommentDate Date/Time ' need this since there could be multiple Comments by manager
CommentText Text or Memo depending on size of comments


and the new Table will have this relationship with Tools
1 ----> Many
Tools-->ToolComments
This requires that you have a Table of Managers

You will be able to search comments by Tool by manager By date or any combination.

You can have a Form /subform arrangement to add/review comments. This is common in Access programs.

You can only add a comment about the TOOL, IF THE TOOL already exists. Said differently, the TOOL must exist before a comment about the Tool can be created.

 

[ScottBeatty]

Makes sense. I have a bunch of data so I'm probably just going to make a new column for comments. Thank you for your help!