Moving in forms

[Sarah at DaVita]

I have a combo box where the user will look up the record they want to edit.
What I want to do is that after click I want the cursor to to to a different
cell. How do I do that? For instance - they select the value while in
combobox1 and I want them to be in combobox 2 when they are done with the
selection.

 

[Ken Sheridan]

Move focus to the second control (not cell, that's a spreadsheet concept) in
the AfterUpdate event procedure of ComboBox1, e.g.

Me.[ComboBox2].SetFocus

Ken Sheridan
Stafford, England

 

[Sarah at DaVita]

Thanks - is there a way to tell it not to highlight all the data but to set
the cursor at the beginning of the data?

Move focus to the second control (not cell, that's a spreadsheet concept) in
the AfterUpdate event procedure of ComboBox1, e.g.

Me.[ComboBox2].SetFocus

Ken Sheridan
Stafford, England

I have a combo box where the user will look up the record they want to edit.
What I want to do is that after click I want the cursor to to to a different
cell. How do I do that? For instance - they select the value while in
combobox1 and I want them to be in combobox 2 when they are done with the
selection.

 

[Ken Sheridan]

Yep, set its SelLength and SelStart properties to zero:

Me.[ComboBox2].SetFocus
Me.[ComboBox2].SelLength = 0
Me.[ComboBox2].SelStart = 0

Ken Sheridan
Stafford, England

Thanks - is there a way to tell it not to highlight all the data but to set
the cursor at the beginning of the data?

Move focus to the second control (not cell, that's a spreadsheet concept) in
the AfterUpdate event procedure of ComboBox1, e.g.

Me.[ComboBox2].SetFocus

Ken Sheridan
Stafford, England

I have a combo box where the user will look up the record they want to edit.
What I want to do is that after click I want the cursor to to to a different
cell. How do I do that? For instance - they select the value while in
combobox1 and I want them to be in combobox 2 when they are done with the
selection.

Ken Sheridan
Stafford, England

I am trying to follow the instructions to set up a combo box based on the
results of a second box from...

http://office.microsoft.com/en-us/access/HA011730581033.aspx?pid=CL100

Per the section "How to add criteria to the product query" I set "Row Source
Type" to Table/Query and click the 3 elipses in the "Row Source" field to get
to the query builder. I have two fields (columns) pulled from one table. The
Table name is "Failure Mode". The two fields are "Failure Type" and "Failure
Mode".

I entered the following statement...
"[Forms]![Failure Mode]![Failure Mode]" in the "Failure Mode" criteria. (I
am looking to select a <Failure Type> and limit my <Failure Mode> selections
to only those items under one <Failure Type>.

After I exit and try to open the form I receive the following Pop up
message...

"ENTER PARAMETER VALUE"
"Forms!Failure Mode!Failure Mode"

What am I doing wrong?

Thanks in Advance.
Dave

 

[Sarah at DaVita]

You are wonderful - Thank you very much.

Yep, set its SelLength and SelStart properties to zero:

Me.[ComboBox2].SetFocus
Me.[ComboBox2].SelLength = 0
Me.[ComboBox2].SelStart = 0

Ken Sheridan
Stafford, England

Thanks - is there a way to tell it not to highlight all the data but to set
the cursor at the beginning of the data?

Move focus to the second control (not cell, that's a spreadsheet concept) in
the AfterUpdate event procedure of ComboBox1, e.g.

Me.[ComboBox2].SetFocus

Ken Sheridan
Stafford, England

:

I have a combo box where the user will look up the record they want to edit.
What I want to do is that after click I want the cursor to to to a different
cell. How do I do that? For instance - they select the value while in
combobox1 and I want them to be in combobox 2 when they are done with the
selection.

Ken Sheridan
Stafford, England

I am trying to follow the instructions to set up a combo box based on the
results of a second box from...

http://office.microsoft.com/en-us/access/HA011730581033.aspx?pid=CL100

Per the section "How to add criteria to the product query" I set "Row Source
Type" to Table/Query and click the 3 elipses in the "Row Source" field to get
to the query builder. I have two fields (columns) pulled from one table. The
Table name is "Failure Mode". The two fields are "Failure Type" and "Failure
Mode".

I entered the following statement...
"[Forms]![Failure Mode]![Failure Mode]" in the "Failure Mode" criteria. (I
am looking to select a <Failure Type> and limit my <Failure Mode> selections
to only those items under one <Failure Type>.

After I exit and try to open the form I receive the following Pop up
message...

"ENTER PARAMETER VALUE"
"Forms!Failure Mode!Failure Mode"

What am I doing wrong?

Thanks in Advance.
Dave