I have a datasheet as a subform which has an unbound field on it.  If I type a value into the unbound
field the value is copied to all records, not just the one I am entering in to.

Any ideas how to solve this,
Ben

On Thu, 23 May 2002 17:39:39 "Ben Ewards" wrote:

> I have a datasheet as a subform which has an unbound field on it.  If 
> I type a value into the unbound field the value is copied to all
> records, not just the one I am entering in to.
> 
> Any ideas how to solve this,
> Ben
> ---
Clear it in an event procedure after each record is written.
Paul

Could you please be a bit more specific, I am fairly new to access.

regards,
Ben

> On Thu, 23 May 2002 17:39:39 "Ben Ewards" wrote:

> I have a datasheet as a subform which has an unbound field on it.  If 
> I type a value into the unbound field the value is copied to all
> records, not just the one I am entering in to.
> 
> Any ideas how to solve this,
> Ben
> ---
Clear it in an event procedure after each record is written.
Paul

Ben,

An unbound field is not associated with a record - its value is only
displayed, not copied to all records.
The only way you will get around this "feature" of access is to base the
subform on a query which has a dummy field. That field becomes the control
source of your previously unbound field.

David

-----Original Message-----
From: Ben Ewards [mailto:ben@c...]
Sent: Thursday, May 23, 2002 5:40 PM
To: Access
Subject: [access] Uning Unbound fields on datasheet


I have a datasheet as a subform which has an unbound field on it.  If I type
a value into the unbound field the value is copied to all records, not just
the one I am entering in to.

Any ideas how to solve this,
Ben