automatically updating a table

[phillier]

I have a form used to create an inventory of items. Associated with
the form is a table of items that have been previously entered. When
I enter an item that is on the list it automatically fills 2 form
fields; one with the item name and one with some additional info. In
order to type in an item name that is not in the table I must go to
the table and enter then return to the form. I would like to be able
to fill in the info to the form and have the table automatically
updated with the new item info. Is this possible?

 

[Guest]

If you use a combobox you can set the Limit To List to No.

 

[phillier]

If you use a combobox you can set the Limit To List to No.

But then how do I have what I type into the form automatically update
the table?

 

[Guest]

In the property Not on List create a macro or event to add a record to your
table from the form field.

 

[Pat Hartman \(MVP\)]

Here's a link to an example - not in list demo - that should help you
http://www.candace-tripp.com/pages/access_downloads.aspx

 

[phillier]

Thanks a lot, I got it to work. Now, does anyone now if it is
possible to have a drop down menu automatically open when you begin
typing in it? So that you can start typing a word and see it in the
menu and select it.

 

[Pat Hartman \(MVP\)]

Auto fulling is the default behavior

Thanks a lot, I got it to work. Now, does anyone now if it is
possible to have a drop down menu automatically open when you begin
typing in it? So that you can start typing a word and see it in the
menu and select it.

 

[phillier]

Autofilling is not the issue. I want the dropdown table to dropdown when I start typing, not when I click the arrow. I want to see the entire list as I type.


- Show quoted text -

 

[Pat Hartman \(MVP\)]

In the onEnter Event of the control -

Me.yourcontrolname.Dropdown