A
Armando Ruiz
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
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