Stop a subform unbound textbox adding value to whole column

[kenb214]

Hi,

I`m quite new to access. I am using access 2003.

I have a subform normally set to datasheet view based on a table and a query and I would like to be able to manually enter values into one of the fields (different values for each record).

Leaving the subform the way it is I cannot enter any values in any fields in the form. If I make the field unbound I can enter a value into it but this creates a new problem - all records then have this manually entered value automatically entered when i click off the field. If I change the value in another record field all the values then change to that value.

How can I top this happening - its driving me crazy!!!

Many thanks in advance.

Ken

 

[boblarson]

First, unbound means it will not save to the table. So your entry will go away.

I'm sure you want bound but your recordset for the subform appears to be non-updateable and you can look here for reasons why that may be. Also, I find that many times people mistakenly include the table which is part of the MAIN form in the recordset of the subform and it should not be there. So if it is, remove it.