By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,405 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

Form input to modify table.

P: n/a
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!

Aug 8 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Wed, 08 Aug 2007 13:52:26 -0000, ja*******@instruction.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!
Aug 8 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.