 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 2005DoCmd.Open form
I want to open a form and restrict which records are displayed on it... here's what I've got: DoCmd.OpenForm "frmConfigValue", , , "Key = 'TargetArchive'" Problem is that all the records from the table are being displayed on the form... the Whereclause above doesn't seem to be having an effect... any idea what the problem is here? Its seems to be OK. Does the records display in a subform? If that the case the where statement doesn't apply to sub form, only to the main form  SignatureIf I answered your question, please mark it as an answer. That way, it will stay saved for a longer time, so other can benifit from it. Good luck > I want to open a form and restrict which records are displayed on it... > here's what I've got: [quoted text clipped - 4 lines] > form... the Whereclause above doesn't seem to be having an effect... any idea > what the problem is here? No, the form I'm opening, frmConfigValue, is to open as a form itself, not as a sub-form inside another form.... > Its seems to be OK. > Does the records display in a subform? If that the case the where statement [quoted text clipped - 8 lines] > > form... the Whereclause above doesn't seem to be having an effect... any idea > > what the problem is here? Do you have any code on the Load event of the form, where you might change the record source? SignatureIf I answered your question, please mark it as an answer. That way, it will stay saved for a longer time, so other can benifit from it. Good luck > No, the form I'm opening, frmConfigValue, is to open as a form itself, not as > a sub-form inside another form.... [quoted text clipped - 11 lines] > > > form... the Whereclause above doesn't seem to be having an effect... any idea > > > what the problem is here? Oops... yea that's it... I should have remembered that... So now, will I be able make use of the paramter in that DoCmd.Open command? If so, how? > Do you have any code on the Load event of the form, where you might change > the record source? [quoted text clipped - 14 lines] > > > > form... the Whereclause above doesn't seem to be having an effect... any idea > > > > what the problem is here? Yes you can, try and pass the criteria using the OpenArgs DoCmd.OpenForm "frmConfigValue", , , , , ,"Key = 'TargetArchive'" On the Load event you can add the OpenArgs as a criteria Me.RecordSource = "Select TableName.* From TableName Where " & Me.OpenArgs SignatureIf I answered your question, please mark it as an answer. That way, it will stay saved for a longer time, so other can benifit from it. Good luck > Oops... yea that's it... I should have remembered that... > [quoted text clipped - 19 lines] > > > > > form... the Whereclause above doesn't seem to be having an effect... any idea > > > > > what the problem is here? |
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.