Does anyone know how can I hide and unhide columns of a
datasheet form programatically. The form I'm trying to
hide columns from is a subform on a parent form, but I
think that doesn't matter in any case.
What I want to do is to reset its recordsource having the
following columns:
ProdId, ItemDescription, Unit, Price1, Price2, Price3
Instead of having three price columns I want to have just
one and reset it to the next field by reseting the form's
recordsource. Instead of having four forms and hiding
them and showing them when I need them. the fourth form
does show all the fields though. So i just want to work
with the fourth form, but I want to show the price's
columns when i need them.

Can anyone tell me how to accomplish this task?

Thank you all in advance.
Armando Ruiz

Use the visible property e.g.
if price1 > 100 then
subform!txt1.visible = true
end if


>-----Original Message-----
>Does anyone know how can I hide and unhide columns of a
>datasheet form programatically. The form I'm trying to
>hide columns from is a subform on a parent form, but I
>think that doesn't matter in any case.
>What I want to do is to reset its recordsource having
the
>following columns:
>ProdId, ItemDescription, Unit, Price1, Price2, Price3
>Instead of having three price columns I want to have
just
>one and reset it to the next field by reseting the
form's
>recordsource. Instead of having four forms and hiding
>them and showing them when I need them. the fourth form
>does show all the fields though. So i just want to work
>with the fourth form, but I want to show the price's
>columns when i need them.
>
>Can anyone tell me how to accomplish this task?
>
>Thank you all in advance.
>Armando Ruiz
>.
>