 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / June 2007Find an specific record based
I have a table where I have : IDDataBase Part ID WOID Cut_Process Cut_Process_Date ============================================== AutoNumber Text Number Yes/No Date/Time these field are updated at the begin of the process IDDataBase Part ID WOID but then at the middle of the process we need to update Cut_Process & Cut_Process_Date , I have created a Form to update these field, but I don't know how to go to the specific record just Typing a WOID number previously updated please help with any ideas to make this works  SignatureLorenzo Díaz Cad Technician Are your WOID numbers unique? If so, you could create a combo box on your form using the wizard. Select the appropriate fields and options as you go through the wizard and it will set it all up for you. Then, by select a particular WOID in the combo box, your form will go directly to that record. If they are not unique, you could click in the field and then Ctrl+F or click the 'Binoculars' icon in your menu bar and search for a particular WOID. If there are more than one, you can just click the 'Find Next' button. Steve > I have a table where I have : > [quoted text clipped - 10 lines] > > please help with any ideas to make this works DoCmd.OpenForm "YourFormName" , , , "WOID =" & Me.WOID put that into an [Event Procedure] on a command button and you will open the form to the record(s) for that WOID. If you use a combo box's after update event it might look like: Me.RecordsetClone.FindFirst "WOID = " & Me.ComboBoxName Me.Bookmark = Me.RecordsetClone.Bookmark or use the combobox wizard SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > I have a table where I have : > [quoted text clipped - 11 lines] > > please help with any ideas to make this works Hello Arvin, thank you so much for your help, it works perfectly Thanks again SignatureLorenzo Díaz Cad Technician > DoCmd.OpenForm "YourFormName" , , , "WOID =" & Me.WOID > [quoted text clipped - 23 lines] > > > > please help with any ideas to make this works |
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.