Continuous form replicating unbound textbox to all rows after update

[DoubleD]

Hi,

I am using Access 2007 and am very new to continuous forms. I am trying to figure out what I'm doing wrong or maybe I'm going about this the wrong way.

I have a continuous form that gets it's data from a query. The query is getting data from 2 tables that are linked using a Left Join.

All of the text box controls on my form populate as expected. I then placed an unbound text box on the form which will be used for user input. When I type anything into this text box, the value is replicated to all rows on the form.

How do I stop this from happening?

[Seth Schrock]

You can't. Unbound controls within the Detail section on a continuous form behaves like that. Your only other option would be to place the textbox in either the header or footer.

[DoubleD]

Thanks Seth. I can't have the control in the header or footer as it needs to form part of the data.

I tried adding a blank column to the query, but that does not allow for user input.

I'll have to find another way to do this then.

[Seth Schrock]

Sorry I couldn't provide a better answer, but that is one of the limitations of continuous forms.

[Rabbit]

Your only real option is to add a field to the table on the left side of the join.

[DoubleD]

Thanks Rabbit and Seth. I did add the field in the table and this resolved my issue.