If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
I Give Up! Can't select name from drop down.
=?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 |
|
Thread Tools | |
Display Modes | |
|
|