form fields and problems with recording data into the table from the forms

[A]

Hi Everyone !

I have a form in my database that allows me to enter in data from the field
text box and its called "notes". So it appears to write to the table
records
in the "notes" field.

But the problem is that I have other forms with a text boxes and I labelled
the box as "notes" but when I search for data or go to the particular record
using this form, nothing appears to show up in my "notes" text field, but
the other fields show the data from the tables.

How can I fix this so I have to option to enter the "notes" data into the
fields and have them not only recorded in the tables, but also show up
in the text box of the forms when I get to the forms.

Please help.

[Mike Storr]

On Thu, 12 Feb 2004 16:14:35 -0500, A wrote:

Hi Everyone !

I have a form in my database that allows me to enter in data from the field
text box and its called "notes". So it appears to write to the table
records
in the "notes" field.

But the problem is that I have other forms with a text boxes and I labelled
the box as "notes" but when I search for data or go to the particular record
using this form, nothing appears to show up in my "notes" text field, but
the other fields show the data from the tables.

How can I fix this so I have to option to enter the "notes" data into the
fields and have them not only recorded in the tables, but also show up
in the text box of the forms when I get to the forms.

Please help.

Make sure the controlsource for all textboxes linked to this field have
been set to the field name (provided the fomr is bound to the table or
query that contains this field)

--
Mike Storr
veraccess.com

[A]

How do i make it bound ?
"Mike Storr" <st******@sympatico.ca> wrote in message
news:1m******************************@40tude.net.. .

On Thu, 12 Feb 2004 16:14:35 -0500, A wrote:

Hi Everyone !

I have a form in my database that allows me to enter in data from the field text box and its called "notes". So it appears to write to the table
records
in the "notes" field.

But the problem is that I have other forms with a text boxes and I labelled the box as "notes" but when I search for data or go to the particular record using this form, nothing appears to show up in my "notes" text field, but the other fields show the data from the tables.

How can I fix this so I have to option to enter the "notes" data into the fields and have them not only recorded in the tables, but also show up
in the text box of the forms when I get to the forms.

Please help.

Make sure the controlsource for all textboxes linked to this field have
been set to the field name (provided the fomr is bound to the table or
query that contains this field)

--
Mike Storr
veraccess.com

[Mike Storr]

On Fri, 13 Feb 2004 15:50:50 -0500, A wrote:

How do i make it bound ?

Open each form in design view that contain this "notes" field. Check the
property sheet for the control in question, it's ControlSource must be set
to the name of the field. Each form you do this on must have a RecordSource
property set to something (query/table) that contains this field. If the
table or query name is "tblNotes" then the form RecordSource property must
be set to "tblNotes".
--
Mike Storr
veraccess.com