Combo box record integrity

[Guest]

On my form is a text box (size 60) called Organization. Rather than use the
record selector to find the appropriate record, I decided to change this
field to a combo box to allow the user to select from the drop down or to
enter a letter & it jump there. It seems to work, but the record selector
remains at 1 so it thinks I'm changing the first record. I need the the
record to advance & show the appropriate data based on the user selection in
the combo box. I've tried building the box based on accessing a table or a
query.

 

[Nikos Yannacopoulos]

Nigel,

Change the combo back to a textbox (or remove it altogether). Then add a
combo in the form's header section, and select the combo wizard's option
for "find a record on my form based..."; just follow the wizard.

HTH,
Nikos

 

[Guest]

Worked, thanks

Nigel,

Change the combo back to a textbox (or remove it altogether). Then add a
combo in the form's header section, and select the combo wizard's option
for "find a record on my form based..."; just follow the wizard.

HTH,
Nikos

 

[Marshall Barton]

Nice going Nikos.

It took me three posts to get to the same answer in Nigel's
other thread with this question.

 

[Guest]

True, but I didn't understand why until you explained the bound versus
unbound. I didn't try Nikos response until you also reponded with an
explanation. Thankyou again for your help.

Nice going Nikos.

It took me three posts to get to the same answer in Nigel's
other thread with this question.
--
Marsh
MVP [MS Access]

Change the combo back to a textbox (or remove it altogether). Then add a
combo in the form's header section, and select the combo wizard's option
for "find a record on my form based..."; just follow the wizard.

 

[Marshall Barton]

Not an issue for you Nigel, you did just fine (except maybe
for double posting your question, but even that is
understandable since you were trying to apply an answer to
someone else's question).

I was just complementing Nikos for getting to core of your
problem so quickly.

 

[Nikos Yannacopoulos]

Thanks, Marsh, a feather in my hat!