Connie-
Won't work - at least not the Modal part. That has to be set before the
form opens.
Consider passing an OpenArgs to the form to tell it to hide all the
buttons, then do the button.Visible = False in the Load event of
Search_HomeInfo.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: mrsgoudge <no_reply@yahoogroups.com>
Reply-To: <MS_Access_Professionals@yahoogroups.com>
Date: Tuesday, November 6, 2012 6:16 PM
To: <MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] DoCmd.OpenForm and then hide buttons on that form
'Open Search_HomeInfo form with current listings, hiding buttons and
making modal
DoCmd.OpenForm "Search_HomeInfo"
Forms!Search_HomeInfo.btnChange.Visible = False
Forms!Search_HomeInfo.btnTracking.Visible = False
Forms!Search_HomeInfo.Command125.Visible = False
Forms!Search_HomeInfo.cboAddress.Visible = False
Forms!Search_HomeInfo.cboParcelN.Visible = False
Forms!Search_HomeInfo.Refresh
Forms!Search_HomeInfo.Modal = True
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar