Drop-down list box with data source from Access

[Sage]

I have inserted a drop-down list box into my form that queries the selection
and inserts the information into fields. The data source is from a MS Access
database. Everything works fine until I preview the form and click a
selection in the drop-down box. When I make a selection the correct
information does show but when I try to click back on the drop-down box to
select a different name, the only values in the box are a blank and the value
that has already been selected. The other names in the drop-down box will not
show until I click on the blank. Is there something I am doing wrong? Aren't
all values of the drop-down box supposed to show no matter what has already
been selected?

 

[Shiva (GGK Tech)]

Hello,

How you are getting dropdown values using any code or rule?
Check it once your rule gets fired when you are changing the dropdown value.
Check it once your code when you are querying the secondary data source
values any condition is there before executing your code.

 

[Sage]

The only rule set was to query the data connection using the main data
source. This all works the only thing is that after it queries the database
and inserts the correct information into the fields the only value showing in
the drop down list is the data that has already been queried.