GoTo from combo on form

[Don]

I can't believe I'm having this much trouble but I can't get this to work. I
have simple table with 2 field - empname and ID which is Autonumber. I have a
form with a combo box for the empname and a textbox for the ID. All I want to
do is click the combo box, click on an employee name and have the info on the
form - the name and ID - displayed for the emp I chose. All I get is it tries
to edit the old record - which happens to be the first record, with the name
of the emp I chose from the combo. How do I get this to quit editing the
record and goto the record I chose?

 

[Arvin Meyer MVP]

I can't believe I'm having this much trouble but I can't get this to work.
I
have simple table with 2 field - empname and ID which is Autonumber. I
have a
form with a combo box for the empname and a textbox for the ID. All I want
to
do is click the combo box, click on an employee name and have the info on
the
form - the name and ID - displayed for the emp I chose. All I get is it
tries
to edit the old record - which happens to be the first record, with the
name
of the emp I chose from the combo. How do I get this to quit editing the
record and goto the record I chose?

Your Combo is bound to the data instead of being an unbound search combo. If
you recreate it using the wizard from the tool box, choose the last choice
(the 3rd one) in the list (Find a record on my form based on my choice in
the combo box)

 

[Don]

I have used the wizard and it still doesn't work. I'm using Access 2007 and
when the wizard comes up I only have two choices when I select a combo box:
"I want the combo box to look up the values in a table or query" and "I will
type in the values that I want". It procedes to create an unbound CB and I
add the empname and empid fields as text boxes and when I run it the name in
the CB changes but the data is not refreshed in the text boxes. I have put a
Requery on the CB On Click event as well as the AfterUpdate event and still
no go. Any more suggestions? I have been messing with this and reading and
messing for days and can't get it to work

 

[Arvin Meyer MVP]

Your form needs to be bound to a recordsource and perhaps isn't.