With my current problem I can't think of a way around not seeing
outside of "Me." I have a check box on a form. If checked, I want the
date to be prefilled on a subform when new records are inserted there.
I can't see the default value propery of the date field in the subform
from the checkbox event on the main form. (I don't know how. I don't
see it under anything that comes up when you type 'me.')
"Me" is just a shortcut. You don't have to use it. To reference a form (even
the form you're in) you can use the syntax Forms!Formname in place of Me
(where Formname is replaced with your formname).
To reference a subform from within the main form, you would use:
Me.Subformcontrolname.Form to reference the subform (you're basically
referencing the Form property of the subform control, which = the subform
itself). Using the above substitution for Me, if you prefer, you could
instead use Forms!Formname.Subformcontrolname.Form instead of the version
with Me.
You can also reference the main form from the subform, either by using the
Forms!formname syntax (which allows you to open any open form, including the
one containing the subform); or you can just use the Parent property of the
subform to reference the main form, as in: Me.Parent. (Note that though
Forms!formname allows you to reference any open form, you still have to use
the other sytax to reference an open subform).
So, with your above example, I would just reference the parent from the
subform. In the subform's BeforeInsert event, I would add:
If Me.Parent.CheckboxcontrolName Then
Me.Datecontrolname = VBA.Date
End If
If you instead want to set the default property for that field when the
check box is checked, you would just use the above syntax for a subform,
etc. But, for me personally, I prefer the above method of looking at the
check box state at the time the record is entered and just going from there.
So I decided
to set the default value for the table (not the form) in the pop-up
date selector form (the button is on the main form). I get a "runtime
error 2465 - Client database can't find the field '|' referred to in
your expression." (There is no '|' in the expression...) The offending
code is: [Court Dates]![DefaultValue] = Me.DateCtl.Value - so I guess
you can't change default values in tables from within forms in
Microsoft 2000. Being a 'c' programmer, this is rather maddening. I'm
used to being able to easily reference anything in the known universe.
It's just a question of syntax. To change a default table value you'd have
to access the table's Tabledef in the Tabledefs collection and go from
there. But, obviously, that's not needed, and isn't the best way to go.
Really, I understand your frustration. But I think until you sit down and
systematically get up to speed with Access syntax and methodologies you're
going to continue to experience these frustrations. Every platform is
different, as you know. So, even just going through the basics of an intro
to VBA Access programming would be very helpful, you'd fine.
Another thing is I don't know how to reference things on the form that
called the popup from withing the popup. (Another reason I tried
changing the default table value. How do you get the selected date
back to the form?)
In the above you reference a subform; here you're discussing a pop-up.
They're not the same thing. A pop-up form (which is different than a dialog
box) is a standalone form, and you can reference it, or it can reference the
form that opened it, using the Forms!Formname syntax.
A short reference on globally referencing things (all in the same
page, not spread out over 50 pages) would be soooo usefull.
Hopefully the above will help.
Neil
