I Give Up! Can't select name from drop down.

Here's the situation. The table that halds the FSM information has numerous
fields. The 3 of most concern are the Site (Text but the primary key) the
Site Status (must filter on Active) and the FSM. An FSM can be used with
more than one site, so if I don't use Unique Values, then each FSM is listed
multiple times in my drop down (for each site the FSM is listed with). The
report, when run, I want the user to be able to choose from the drop down the
FSM. That way all the records for that FSM will be displayed in the report.
The report is based on a chain of queries and none of them have the FSM as a
field, otherwise it would be much easier to filter; but the queries it does
use eventually have a table that links with this Sites table and subsequent
query. I realize that a table with the FSMs is a better way to go, but I did
not design the dbase and it would be quite tasking to try and fix it now.
So, with all that said, do you have any other thoughts of how I can do what I
am trying to do?

Thanks for all your help.

"Bob Quintal" wrote:

=?Utf-8?B?U1ZF?= wrote in
:

No, I had already checked that. Locked is set to no and allow
edits is set to yes.

Thanks again. Any other thoughts?

What is the control source of the combo box? Is it something that
Access thinks is not updateable?

***********
I Googled your original post.You say that you have a distinct clause
in the query, That makes the query non-updateable.

You said
FYI--This form will be used to filter a report when all is said and
done.

If this is the case, you do not want to bind the combo box to the
query's field, you simply want to use it as criteria for a report.

I think you don't need to bind the form to the query at all,.

Q

"Bob Quintal" wrote:

=?Utf-8?B?U1ZF?= wrote in
:

Thanks. I tried this, but although the primary key is a text
field, I had no formatting for the field and Concatenation did
not solve the problem. Unlike RxDave, I can see my list of
names and even highlight them, but I can't select them. Any
other ideas?

Thanks for all your help.

"Dirk Goldgar" wrote:

In ,
SVE wrote:
Thank you for your quick response. Yes it is set to allow
edits.

RxDave has posted, in this thread, a link to a new bug that I
was only vaguely aware of. Could that be the source of your
problem?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


is it possible that the combobox locked property is set to yes?
or that the form's allow edits property is set to no?



--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com






--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

=?Utf-8?B?U1ZF?= wrote in
:

Here's the situation. The table that halds the FSM information
has numerous fields. The 3 of most concern are the Site (Text but
the primary key) the Site Status (must filter on Active) and the
FSM. An FSM can be used with more than one site, so if I don't
use Unique Values, then each FSM is listed multiple times in my
drop down (for each site the FSM is listed with). The report,
when run, I want the user to be able to choose from the drop down
the FSM. That way all the records for that FSM will be displayed
in the report. The report is based on a chain of queries and none
of them have the FSM as a field, otherwise it would be much easier
to filter; but the queries it does use eventually have a table
that links with this Sites table and subsequent query. I realize
that a table with the FSMs is a better way to go, but I did not
design the dbase and it would be quite tasking to try and fix it
now. So, with all that said, do you have any other thoughts of
how I can do what I am trying to do?

Thanks for all your help.

There is nothing unusual about your situation.

Use the Combobox on an unbound form. Its Row Source should be your
distinct query that calculates your FSM. You may have an unbound
checkbox If you wish to enable the report to print active/inactive
rows. You'll also need a command button to run the report.

Build your report using a query that returns all records.

There are two options you can use to actually run the report.

Option 1: In the query, add references to the unbound form's
combobox (and checkbox) in the criteria row against the columns you
need to filter like Forms!formname!controlname
Then you simply open the form by clikcing the command button.

Option 2: Instead of putting the references to the form into the
query, you put them into the vba code which opens the report

stWhereClause = "FMS= """ & me.cboFMS & """"
Docmd.Openreport stDocname,,,stWhereClause



"Bob Quintal" wrote:

=?Utf-8?B?U1ZF?= wrote in
:

No, I had already checked that. Locked is set to no and allow
edits is set to yes.

Thanks again. Any other thoughts?

What is the control source of the combo box? Is it something that
Access thinks is not updateable?

***********
I Googled your original post.You say that you have a distinct
clause in the query, That makes the query non-updateable.

You said
FYI--This form will be used to filter a report when all is said
and done.

If this is the case, you do not want to bind the combo box to the
query's field, you simply want to use it as criteria for a
report.

I think you don't need to bind the form to the query at all,.

Q

"Bob Quintal" wrote:

=?Utf-8?B?U1ZF?= wrote in
:

Thanks. I tried this, but although the primary key is a
text field, I had no formatting for the field and
Concatenation did not solve the problem. Unlike RxDave, I
can see my list of names and even highlight them, but I
can't select them. Any other ideas?

Thanks for all your help.

"Dirk Goldgar" wrote:

In ,
SVE wrote:
Thank you for your quick response. Yes it is set to
allow edits.

RxDave has posted, in this thread, a link to a new bug that
I was only vaguely aware of. Could that be the source of
your problem?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


is it possible that the combobox locked property is set to
yes? or that the form's allow edits property is set to no?



--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com






--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com






--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com