Prev: Combo Box not displaying properly
Next: Blank Template with rows and columns
From: LFC on 22 Apr 2010 16:17
I have a form in which I have an unbound textbox so that users can add
comments about the record. I type something into the textbox on one of the
records and it fills whatever I wrote into all other records. I want what
gets typed to just stay on the one record. Any ideas?
From: Dirk Goldgar on 22 Apr 2010 16:23
"LFC" <LFC(a)discussions.microsoft.com> wrote in message
news:695DCB42-BF79-4F77-BEF7-03A0ED7E4F68(a)microsoft.com...
>I have a form in which I have an unbound textbox so that users can add
> comments about the record. I type something into the textbox on one of
> the
> records and it fills whatever I wrote into all other records. I want what
> gets typed to just stay on the one record. Any ideas?


The obvious answer is to bind the text box to a field in the record. Is
there a reason that the text box has to be unbound?

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

From: ghetto_banjo on 22 Apr 2010 16:24
create a "comments" field in your table (if its not there already),
and then make the textbox bound to this field. otherwise it is just
on the form and not being stored anywhere.
From: John W. Vinson on 22 Apr 2010 16:52
On Thu, 22 Apr 2010 13:17:01 -0700, LFC <LFC(a)discussions.microsoft.com> wrote:

>I have a form in which I have an unbound textbox so that users can add
>comments about the record. I type something into the textbox on one of the
>records and it fills whatever I wrote into all other records. I want what
>gets typed to just stay on the one record. Any ideas?

That's what unbound MEANS. It's not stored anywhere, and it's not associated
with any record.

If you want it associated with a record, you'll need to store it in a table
and bind that stored field to a textbox on your form.

If you will have one and only one comment per record, you can just add a Text
or Memo field to the table. However, it's pretty common to want to allow
multiple comments; this can be done by adding a Comments table, with fields
for a foreign key linked to the record's Primary Key, a Memo or Text field to
store the comment, and perhaps a date/time field defaulting to Now() to
timestamp the comment and a field to store the identity of the person making
the comment.
--

John W. Vinson [MVP]
From: LFC on 27 Apr 2010 10:21
I had tried making it bound to a table, but since I'm querying from multiple
tables if I try to type into a comments field it won't let me because it says
the field is not updateable.

"Dirk Goldgar" wrote:

> "LFC" <LFC(a)discussions.microsoft.com> wrote in message
> news:695DCB42-BF79-4F77-BEF7-03A0ED7E4F68(a)microsoft.com...
> >I have a form in which I have an unbound textbox so that users can add
> > comments about the record. I type something into the textbox on one of
> > the
> > records and it fills whatever I wrote into all other records. I want what
> > gets typed to just stay on the one record. Any ideas?
>
>
> The obvious answer is to bind the text box to a field in the record. Is
> there a reason that the text box has to be unbound?
>
> --
> Dirk Goldgar, MS Access MVP
> Access tips: www.datagnostics.com/tips.html
>
> (please reply to the newsgroup)
>
 |  Next  |  Last
Pages: 1 2 3
Prev: Combo Box not displaying properly
Next: Blank Template with rows and columns