goto

  • Thread starter Thread starter AlTamres
  • Start date Start date
A

AlTamres

I have a subform in a main form.
The main form has a combo box that selects a record for the main form and
updates the subform for that record.
I want to goto the subform after I update a record in the main form. or
combo box.
Thanks in advance for your help I finding a solution in advance
Help Al
 
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
 
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.)
 
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

Douglas J. Steele said:
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)


AlTamres said:
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
Click to expand...
Click to expand...
 
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!)


AlTamres said:
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

Douglas J. Steele said:
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)


AlTamres said:
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
Click to expand...
Click to expand...
Click to expand...
 
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

Douglas J. Steele said:
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!)


AlTamres said:
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

Douglas J. Steele said:
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
Click to expand...
Click to expand...
Click to expand...
 
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!)


AlTamres said:
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

Douglas J. Steele said:
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!)


AlTamres said:
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

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
Click to expand...
Click to expand...
Click to expand...
 
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

Douglas J. Steele said:
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!)


AlTamres said:
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

Douglas J. Steele said:
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

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
Click to expand...
Click to expand...
Click to expand...
 
Just overtype it in the Properties sheet.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


AlTamres said:
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

Douglas J. Steele said:
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!)


AlTamres said:
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

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
Click to expand...
Click to expand...
Click to expand...
 
Thanks again Al
Do you want another problem?

Douglas J. Steele said:
Just overtype it in the Properties sheet.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


AlTamres said:
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

Douglas J. Steele said:
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

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
Click to expand...
Click to expand...
Click to expand...
 
Start a new post.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


AlTamres said:
Thanks again Al
Do you want another problem?

Douglas J. Steele said:
Just overtype it in the Properties sheet.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


AlTamres said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top