How to hide one record in continuous form

[cambo]

Hello all expert
I have one continuous form
I want to update information on any one textbox
or hide one record on my continuous form
but i don't know how todo?
because when i use insert textbox to calulate like
quantity * price when I update all textbox will change all
values in all textbox the same.
Please help me.

 

[cambo]

My problem is that
I have 2 tables one to many relationship.
first I create query to by select all from first table and sum value of
second table relationship.
if I use this query i cannot insert new record with continuous form.

now I want to sum value from second table and get this value to display on
textbox on continuous form of the first table by corret ID.

ok thanks..

Hello all expert
I have one continuous form
I want to update information on any one textbox
or hide one record on my continuous form
but i don't know how todo?
because when i use insert textbox to calulate like
quantity * price when I update all textbox will change all
values in all textbox the same.
Please help me.

Your question is confusing. You want to hide one record - row - in the
form;
but your example does not refer to a row, but to a field (a column).

If it is in fact a field that you mean, the solution is to do the
calculation
in the Query upon which the form is based rather than in the control
source of
a textbox. A continuous form *appears* to have many textboxes for each
field,
one for each row; but in reality it has only one textbox, displayed many
times. Changing its properties - e.g. its control source - changes all of
the
instances of the control.

Just base your Form on a Query with a calculated field. In a vacant Field
cell
in the query grid type

ExtPrice: [Quantity] * [Price]

You'll see the extended price displayed on every row using the data in
that
row. Of course the field won't be editable, but you wouldn't want it to
be!

 

[Larry Linson]

I can help you

So why did you not do so, instead of bragging on your ability? Did you
expect the poster to _pay_ you to help him? That's not what these
newsgroups are about -- there are volunteers who donate uncoounted hours of
time and un-measurable energy providing answers for free.

Larry Linson
Microsoft Office Access MVP