Combo Box Integrity

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can get my combo box to populate the fields with the correct related data
based on the choice made in the combo box. However, when using the next and
previous arrows, the populated fields change but the selection in the combo
box does not. I have done this successfully before, but can't find the notes
as to how I did it.

Additionally, I posted this question yesterday but can't seem to find the
dialog I had going when I looking in the discussion groups this morning.
 
It sounds as if the combobox is unbound.

It should probably be bound to a field AND the population code reside
in the oncurrent event also.

Ron
 
Hi Ron - the combo box is unbound, but I have the same situation in 2 other
databases and those are unbound as well - but they work. I can't remember
how I created the other combos in those databases.
So you're saying that it should be bound to a field...I'll give that a try,
thanks!
 
Hi Ron,
No dice. I had forgotten that by binding it to a control that it violates
the primary key rule of no dupes - and the combo list is the primary key.
I've been working on this stupid thing for two days: I've been successful
with this very thing before on 2 databases - same everything (well, except
for the fields names, obviously). I cannot for the life of me figure out why
this one won't work.
 
Then, lets's flip the logic around. Since it is not bound, should you
perhaps be loading it from the record you are on in the oncurrent event
of the form.

Changing it causes it to load data on the current record, so when you
change records you will have to turn around and load it from the
record.

Maybe.....

Ron
 
Hi Ron,
What I have in sql on my other db's is a private sub, form_current(),
combo177 = brochure....and that works.
However, get this: when I do that exact same code in the new db, it works
by changing the data betwee records, BUT the actual data being chosen from
the combo box disappears from being displayed on the form. It is the
damndest thing. I'm at my wits end, and it was a short trip to start with.
 
hmmmmmm......

Not sure I have any more ideas. Have just not encountered that type of
problem before.

I hope someone else has some idea.

Ron
 
Back
Top