Unbound field in a continuous form

[Mike Davidson]

It's been a while since programming in Access and I'm
baffled. This should be so easy.
I have a form with Default View = Continuous Forms.
The form will accept data in two fields, Quantity and
Price to calculate the third field, Total.
Quantity is a bound field.
Price and Total are unbound. (will be used in later calc)
When I type a value in Price, it displays in all the other
records in the form. What am I doing wrong? Thanks, Mike

 

[fredg]

It's been a while since programming in Access and I'm
baffled. This should be so easy.
I have a form with Default View = Continuous Forms.
The form will accept data in two fields, Quantity and
Price to calculate the third field, Total.
Quantity is a bound field.
Price and Total are unbound. (will be used in later calc)
When I type a value in Price, it displays in all the other
records in the form. What am I doing wrong? Thanks, Mike

Mike,
In continuous form view, an unbound control is just that, unbound to
any particular record in the table. So if you are showing 15 records
in the view, you are getting the same 1 unbound control displayed 15
times.

Use a Single Form view, not continuous.