That was the problem.
When I first created the form the name was = GIVisits Entry Subform
I then changed it to GIVisitsEntrysubform.
Is there a easy way to change the control name to the new form name?
Thanks again
Al
Open the parent form in Design view and select the subform control by
clicking on it (not double clicking!).
Look at the Properties window: what name is there?
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
I don't remember how I entered the subform.
How to I check what the name is?
Yesterday I realized that I need to change the date field to something
else..
Thanks again Doug
Al
message Are you sure that the subform control is named GIVisitsEntrysubform?
As I said earlier, depending on how you added the form as a subform,
the name of the subform control may be different than the name of the
form being used as a subform.
Also, you should really rename your text box. Date is a reserved
word, and reserved words should never be used for your own purposes.
For a comprehensive list of names to avoid (as well as a link to a
free utility that will check your application for compliance), check
what Allen Browne has at
http://www.allenbrowne.com/AppIssueBadWord.html
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
I am having trouble getting the following;
The Main Form name is=GIVisitation
The subform name=GIVisitsEntrysubform
The table that the subform is based on=Visits
The field in the subform is=Date
I entered the following;
Me!GIVisitsEntrysubform.setfocus
Me!GIVisitsEntrysubform.Form!date.setfocus
I get the following Error message
Can not find the field "GIVisitsEntrysubform" referred to in your
expression
An I entering it wrong?
How should it be entered
Thanks for your help and looking for more.
Al
message Me![NameOfSubformControl].SetFocus
Me![NameOfSubformControl].Form![NameOfControlOnSubform].SetFocus
(replace NameOfSubformControl and NameOfControlOnSubform with the
appropriate names. Note that depending on how you added the form as
a subform, the name of the subform control may be different than
the name of the form being used as a subform.)
--
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
I am in a field on the main form. I depress the enter key. I want
the focus / curser to go to the first field in the subform
automatically so that the next stroke of the keyboard enters data
in the subform.
I need help in creating a function or expression to enter into the
main form after update event of the property box.
Thanks for your intrest.
Al
I'm sorry, I don't really see a question here! If you want to go
to the
subform, go to it! Maybe a little more explanation of what you're
trying to
do would be in order.
--
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com
