Form input to modify table.

[jack.vier@instruction.com]

I have a form to add data to a table. That works like a charm. The
part that doesn't work is...

I have a drop-down that when its "On Change" event is triggered it
will make "Visible" and "Enabled" both "Yes" for another object on the
form. The VB code escapes me. For the "Event Procedure" I started to
have "db1.MyForm .". After I typed "db1." I had the option to select
"MyForm", which is the form I am working on, but after I typed a "."
following "db1.MyForm " I didn't get any options/objects/methods to
select.

Can someone give me a hint on what I need to do?

Why doesn't "db1.MyForm ." give me anything to select?

Thanks!

[Tom van Stiphout]

Re: Form input to modify table.

On Wed, 08 Aug 2007 13:52:26 -0000, jack.vier@instr uction.com wrote:

In A2007 intellisense would have continued to work. In older versions
or for some complex expressions it loses track of where it is.
I would write:
With Me.MyDropdown
.Visible = True
.Enabled = True
End With

-Tom.

>I have a form to add data to a table. That works like a charm. The
>part that doesn't work is...
>
>I have a drop-down that when its "On Change" event is triggered it
>will make "Visible" and "Enabled" both "Yes" for another object on the
>form. The VB code escapes me. For the "Event Procedure" I started to
>have "db1.MyForm .". After I typed "db1." I had the option to select
>"MyForm", which is the form I am working on, but after I typed a "."
>following "db1.MyForm " I didn't get any options/objects/methods to
>select.
>
>Can someone give me a hint on what I need to do?
>
>Why doesn't "db1.MyForm ." give me anything to select?
>
>Thanks!