automatically updating a table

  • Thread starter Thread starter phillier
  • Start date Start date
P

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?
 
In the property Not on List create a macro or event to add a record to your
table from the form field.
 
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.
 
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.
Click to expand...
 
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 -
Click to expand...
 
Back
Top