Hide Form SetFocus Issue

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi All,

I am trying to move to forcus to a main form and set a subform to visible =
false

Below is the code. Its not working. Can anyone help?

Me.frmQuotes.SetFocus

Forms!frmQuotes.Form!frmQuoteMultiBid.Visible = False

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200903/1

.

Relevant Pages

  • Find data on main form from subform code
    ... I have some code in my subform. ... mattc saunatec [dot] com ...
    (microsoft.public.access.formscoding)
  • Refresh Form
    ... I have a main form with a subform based on a table. ... to the main form I would like the table data to refresh showing changes. ... mattc saunatec [dot] com ...
    (microsoft.public.access.forms)
  • Re: Add Data to subform
    ... DoCmd.GoToRecord,, acNewRec ' Perform some action. ... However it adds the data to the first record on the subform. ... mattc saunatec [dot] com ...
    (microsoft.public.access.forms)
  • Show Subform data based on main form drop downlists
    ... I have a subform that I have linked to 3 drop down lists on my main form. ... mattc saunatec [dot] com ...
    (microsoft.public.access.forms)
  • Re: Problems referencing Subform Control from another subform
    ... the off chance you typed a dot when an! ... oughtas be, I tried it both ways and ... use the On Current event in subform a to populate data in subform b. ...
    (microsoft.public.access.forms)