Populate Combo Box From Information On A table.

  • Thread starter Thread starter Peanut
  • Start date Start date
P

Peanut

Ok, I've been thinking about how to do this for sometime and I've gotten
close, but nothing seems to be working correctly in the end. I'm sure this
is an easy fix, but I'm overlooking something.

Overview of Problem:
Table One:tblShippingInfo
Table Two:tblCdNumbers

In table one is a list of information that I need to keep track of when I
send things out to a given place.

In table two is just a list of CD Numbers CD 1 - CD 30.

What I need to happen is when a CD Number, exmple(CD 1), has been sent out
to a destination, I dont want it to display in the combo box. It should
display CD 2 - CD 30 in the combo box.

I cant for the life of me figure out this in a query or maybe it doesnt need
to be a query. Please help me if you can, If I'm doing this the wrong way,
please guide me to the correct.
 
Peanut,
You wrote...What, in your data, tells you that the CD has been sent out?"

Use that indication in the RowSource query behind your combobox.
Example..
In your CD table, if you had a field like DateSent...
Any CD that has a date entry in DateSent would be excluded from the
combobox.
Is Null(DateSent)
Just an example... adjust for your particular situation.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top