 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / July 2007automatically updating a table
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? If you use a combobox you can set the Limit To List to No.  SignatureKARL DEWEY Build a little - Test a little > 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 [quoted text clipped - 4 lines] > to fill in the info to the form and have the table automatically > updated with the new item info. Is this possible? On Jun 14, 2:50 pm, KARL DEWEY <KARLDE...@discussions.microsoft.com> wrote: > If you use a combobox you can set the Limit To List to No. > -- [quoted text clipped - 10 lines] > > to fill in the info to the form and have the table automatically > > updated with the new item info. Is this possible? But then how do I have what I type into the form automatically update the table? In the property Not on List create a macro or event to add a record to your table from the form field. SignatureKARL DEWEY Build a little - Test a little > On Jun 14, 2:50 pm, KARL DEWEY <KARLDE...@discussions.microsoft.com> > wrote: [quoted text clipped - 15 lines] > But then how do I have what I type into the form automatically update > the table? Here's a link to an example - not in list demo - that should help you http://www.candace-tripp.com/pages/access_downloads.aspx >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 [quoted text clipped - 4 lines] > to fill in the info to the form and have the table automatically > updated with the new item info. Is this possible? 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. On Jun 15, 3:11 pm, "Pat Hartman \(MVP\)" <please no e...@aol.com> wrote: > Here's a link to an example - not in list demo - that should help youhttp://www.candace-tripp.com/pages/access_downloads.aspx > [quoted text clipped - 12 lines] > > - Show quoted text - 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 [quoted text clipped - 20 lines] >> >> - Show quoted text - On Jun 21, 12:25 pm, "Pat Hartman \(MVP\)" <please no e...@aol.com> wrote: > Auto fulling is the default behavior<phill...@haz-waste.com> wrote in message > [quoted text clipped - 14 lines] > >>news:1181847690.569156.136690@i38g2000prf.googlegroups.com... > 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. > >> >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 [quoted text clipped - 8 lines] > > - Show quoted text - In the onEnter Event of the control - Me.yourcontrolname.Dropdown > On Jun 21, 12:25 pm, "Pat Hartman \(MVP\)" <please no e...@aol.com> > wrote: [quoted text clipped - 36 lines] >> >> - Show quoted text - |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.