concerning subforms...

From: Neal Tipton (tipton_at_gvtc.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 16:25:06 -0600

Group:

1. What is happening when I have to go to the menu bar and select
"records -- refresh" in order to see the contents of my subforms?
2. What's the difference between refresh and requery and why does the Me.
object in VBA have both, but Me.someobjecthere has only the requery method
as an option?
3. How do you reference objects in subforms via VBA?

Thanks,
Neal

Relevant Pages

  • Re: refresh problem
    ... various textboxes and other controls. ... a refresh button, and I added it to the event procedure of my button so ... that, after running the append query, the subforms and textboxes would be ... My problem is that this line works fine on some PCs but on ...
    (microsoft.public.access.forms)
  • Help with DoMenuItem
    ... The subforms hold data from numerous queries based on ... I'm assumming that the 5 is for refresh but can't find the ... I've converted the queries to oracle passthrus. ...
    (microsoft.public.access.modulesdaovba)
  • Re: delay in updating
    ... calculated control is always one step behind in displaying the value. ... The form has two forms and these forms have subforms. ... I suspect also that you are using Refresh when you may need to use Recalc or Requery, ... Is the Returned control part of that calculation? ...
    (microsoft.public.access.formscoding)
  • RE: Excel 2007 Refresh multiple data connections & pass parameter to S
    ... If you refresh via VBA you can add the line ... Regarding the second question is this in Excel's vba or is this part of the ... Each one returns data for a graph. ... Some advice I've received is 2003 specific and didn't work. ...
    (microsoft.public.excel.misc)
  • Re: Using Variable in Where Clause
    ... > parts of the "Facility Table" with subforms that are totally ... > I guess it is time to learn VBA. ... Most Access books will have a lot of code in them. ... I would still look at a tabbed form with the subforms on each page but the ...
    (microsoft.public.access.forms)