 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / June 2007Editing records through a form
I have a table with 1000 items containing information like item name, cost, supplier. I would like to be able to edit these items through a form. How do I allow the user to perform a search on the 1000 items and then select the one that the user wants to edit? That is my problem. I don't know how to allow the user to select the item that he/she wants to edit. Is anyone able to do this using queries and macro? I'm not Access code orrientated. >I have a table with 1000 items containing information like item name, cost, > supplier. I would like to be able to edit these items through a form. [quoted text clipped - 6 lines] > Is anyone able to do this using queries and macro? I'm not Access code > orrientated. If there is a Field in the Table that the user can employ to identify the Record, then the Combo Box wizard will generate code so the user can specify a value, and then it will populate your Form with the Record, or Records, that match (if any). There'll be code, or macros, generated by the Wizard, but you won't have to write any. Larry Linson Microsoft Access MVP Access forms come with a great search feature built right in. It is called filter by form. Select the filter by form icon from the toolbar - between the A-Z/Z-A buttons and the binoculars are three filter buttons. Filter by form is the middle one. Or, you can get to it via Records/Filter/Filter by form. >I have a table with 1000 items containing information like item name, cost, > supplier. I would like to be able to edit these items through a form. [quoted text clipped - 6 lines] > Is anyone able to do this using queries and macro? I'm not Access code > orrientated. |
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.