PROBLEM:
1.  Combo box of a field called Source is reset to the primary key called 
"ID" after a search has been done.


I have a column with a field named "Source" in a table.

In my form I have a Search Entry with "Source" as a combo box.  If no search 
is done, then combo box is showing all the records.  Thus, if a search is 
done and then another search is required, all the entries in the Source 
combo box are gone and the Primary Key "ID" is displayed.

In the Source properties, ...
Source is unbound
Record Source Type chosen is "Table/Query
Record Source is "qry_source"


The select query it also changed showing in the criteria "1"

(I did not indicate anything in criteria of the source query.  All I did was 
dragged the field "Source down to the query and where the source is coming 
from.  As well, display is checked.  That's all.)


Much needed help!

Rick

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

You need to be a lot more clear on what exactly the problem is. From the 
explaination below I cannot figure out what you are trying to do and what 
is happening that is a problem. 

If you can be a little more clear, we will try to help.

Amy

> PROBLEM:
1.  Combo box of a field called Source is reset to the primary key called 
"ID" after a search has been done.


I have a column with a field named "Source" in a table.

In my form I have a Search Entry with "Source" as a combo box.  If no 
search 
is done, then combo box is showing all the records.  Thus, if a search is 
done and then another search is required, all the entries in the Source 
combo box are gone and the Primary Key "ID" is displayed.

In the Source properties, ...
Source is unbound
Record Source Type chosen is "Table/Query
Record Source is "qry_source"


The select query it also changed showing in the criteria "1"

(I did not indicate anything in criteria of the source query.  All I did 
was 
dragged the field "Source down to the query and where the source is coming 
from.  As well, display is checked.  That's all.)


Much needed help!

Rick

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com