Record Selection Combo Boxes

D

Dee

Hi All,

I am at hair pulling out point!!! I am a fairly new user to Access and am
trying to create a combo box that lets you select records from a drop down
menu (an unbound conbo box). The problem I am having is that for instance if
I want to select a status "open" it shows up in the combo box, but if 3
records are open it shows up three times. Any responses would be really
appreciated. Thanks!!!
 
H

HC

Here is what i would do .....

Combo box (Open, closed , etc...)
base on the value you pick on the combo box ....

Create the query with citeria base on the combo box. Create a continous
form for the query.

do the requery on the onclick property on the combo box to refesh the
data for the subform.

IF you have 3 records that were open you will see three.

Hope i'm making some sense and goodluck.
 
Top