Data sheet view or continuous form view

[arnold]

Hi Friends,

I wonder if any body has the solution for the following problem:
My form view is datasheet view and I have unbound text box which is not related to any field but I need it in my form for some purpose. My form might consist of many rows or records. My problem is that when I put specific text in my unbound text box the same text is repeated in all other rows. Hence is there a way which allows me to enter a value in my text box without being repeated in all other rows.
Remark: the same problem occurs when I use continuous form view.

[nico5038]

Hi arnold,

This is a "known" problem with continuous forms. Access doesn't see the controls as "separate" and only a "bound" control can hold different values. So in your case only adding a (dummy) field to the form's recordsource (and/or table) will work.

Nic;o)

[arnold]

Hi arnold,

This is a "known" problem with continuous forms. Access doesn't see the controls as "separate" and only a "bound" control can hold different values. So in your case only adding a (dummy) field to the form's recordsource (and/or table) will work.

Nic;o)

Thanks nico5038 I really appreciate your kind reply