 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007Going to a specific record on a form
Hello, I have a menu with a combo box that will open a form with the chosen record (so the form is based on a filtered query). I also have another function on the menu that I want to allow me to go to the last record on the same form. How can I go about using the combo box to open a specified record without the form being based on a filtered query? thanks  Signaturehttp://www.patriotsquestion911.com http://www.911truth.org http://www.wtc7.net http://www.st911.org http://www.journalof911studies.com http://www.pilotsfor911truth.org http://ae911truth.org Look at this link on "Using a Microsoft Access Combo Box to Search for a Record" http://www.databasedev.co.uk/combo_box_search.html SignatureGood Luck BS"D > Hello, > [quoted text clipped - 8 lines] > > thanks thanks for the reply but I don't think it is quite what I am looking for. The combo box is on the menu and I want to use it to go to a record on a different form that hasn't been opened yet (I am using the after update event in the combo box to open the form). Hoping that makes sense. > Look at this link on "Using a Microsoft Access Combo Box to Search for a > Record" [quoted text clipped - 13 lines] > > > > thanks > thanks for the reply but I don't think it is quite what I am looking > for. [quoted text clipped - 4 lines] > > Hoping that makes sense. The command button wizard has an option for opening a form showing records related to the record on the current form. All you need to do is take that code and use it in the AfterUpdate event of your ComboBox. Essentially you use the OpenForm method a supply a WHERE argument that pre-filters the form being opened. DoCmd.OpenForm "FormName",,,"SomeField = '" & Me.ComboBoxName & "'" If your ComboBox value is numeric eliminate the single quotes. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com thanks. > > thanks for the reply but I don't think it is quite what I am looking > > for. [quoted text clipped - 14 lines] > > If your ComboBox value is numeric eliminate the single quotes. |
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
|
©2009 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.