John and Clive, I did a correction post and the corrected Select stmt for the Record Source is this...
> Record Source: Select stmt in standard module.
CODE:
Forms(FNAME).SUBLIST.Form.RecordSource = "SELECT RID, RESULT, RESULT_DATE,
COMMENTS, CL_ITEM, CL_CATEGORY, CL_ITEM_ID " & _
"FROM LMVMGR_MOD_LOSS_MIT_QC_RESULTS " & _
"WHERE (((ROW_ID)=" & rID & "));"
Thanks again - Mike
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Mike-
>
>
>
> You should only be able to modify the LOAN_NUMBER, MOD_TYPE, and
> MOD_EFFECTIVE_DATE and perhaps the RID and ROW_ID fields if they're not
> AutoNumber. All the other fields are "calculated" and thus not updatable.
>
>
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> <http://www.viescas.com/> http://www.viescas.com/
>
> (Paris, France)
>
>
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mithomas48
> Sent: Friday, June 29, 2012 4:49 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Drop Down Selection in Read Only
>
>
>
>
>
> Clive, see below info as requested...
>
> > Row Source Type: Table/Query
> > Row Source: Select stmt in On Got Focus event
> CODE:
> Me.DTL_RESULT.RowSource = "SELECT LOOKUP_DESC
> FROM LSDMGR_MOD_LOSS_MIT_LOOKUP
> WHERE (((LOOKUP_TYPE)='PASS_FAIL'));"
> > Control Source: Set to the field in the table
> > Bound Column: 1
> > Column Count: 1
> > Record Source: Select stmt in standard module.
> CODE:
> strSQL = "SELECT A.RID, A.ROW_ID, B.LOAN_NUMBER, B.MOD_TYPE, " & _
> "B.MOD_EFFECTIVE_DATE, Format([A].[CREATED_DATE],'mm/dd/yyyy') AS CREATED_DATE,
> " & _
> "(SELECT [USER_FIRSTNAME]+' '+[USER_LASTNAME] AS [USER] FROM
> LSDMGR_USERS_PASSWORDS_USERSPLUS " & _
> "WHERE (((LSDMGR_USERS_PASSWORDS_USERSPLUS.GID)=[A].[CREATED_BY]))) AS
> CREATED_BY, " & _
> "(SELECT LSDMGR_MOD_LOSS_MIT_LOOKUP.LOOKUP_DESC FROM LSDMGR_MOD_LOSS_MIT_LOOKUP
> " & _
> "WHERE (((LSDMGR_MOD_LOSS_MIT_LOOKUP.LOOKUP_TYPE)='QUEUE_STATUS') " & _
> "AND ((LSDMGR_MOD_LOSS_MIT_LOOKUP.LOOKUP_VALUE)=A.QUEUE_STATUS))) AS
> QUEUE_STATUS, " & _
> "(SELECT [USER_FIRSTNAME]+' '+[USER_LASTNAME] AS [USER] FROM
> LSDMGR_USERS_PASSWORDS_USERSPLUS " & _
> "WHERE (((LSDMGR_USERS_PASSWORDS_USERSPLUS.GID)=[A].[QUEUE_ASSIGNED]))) AS
> QUEUE_ASSIGNED, " & _
> "Format([A].[QUEUE_STATUS_CHG_DATE],'mm/dd/yyyy') AS QUEUE_STATUS_CHG_DATE" &
> SQLCOND & " " & _
> "FROM " & dSource & " A " & _
> "INNER JOIN LSDMGR_MOD_LOSS_MITIGATIONS B ON A.ROW_ID = B.ROW_ID " & _
> "WHERE (" & WhereCOND & ") " & _
> "ORDER BY " & OrderCOND & ";"
>
> 'LOAD FORM
> Forms(FNAME).RecordSource = strSQL
>
> You'll notice that I am using some sub queries to capture data for the
> recordset. The drop down loads and lists fine, and when clicking on the drop
> down the option list is displayed fine. The form loads the record source fine. I
> just can't make any changes to any of the fields in the records.
>
> Thanks in advance!
> Mike
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "Clive" <zctek@> wrote:
> >
> > Hi Mike,
> >
> > We need more information.
> >
> > Please give more details about the ComboBox properties,
> > Row Source Type:
> > Row Source:
> > Control Source:
> > Bound Column:
> > Column Count:
> >
> > And also the Form properties,
> > Record Source:
> >
> > Regards, Clive.
> >
> > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , mithomas48 <no_reply@>
> wrote:
> > >
> > > Also, if I debug.pring the select statement used to load the subform, and
> copy that to a new query object, I can edit any field in a record. So I would
> think the query is updateable.
> > >
> > > Thanks again!
> > > Mike
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , mithomas48 <no_reply@>
> wrote:
> > > >
> > > > None of the fields can be changed, and none are locked and they are
> enabled. The only one that needs to be edited however is just the drop down
> field. How can I check if it updateable?
> > > >
> > > > Thanks again!
> > > > Mike
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "sarmbraugh" <sarmbraugh@>
> wrote:
> > > > >
> > > > > Make sure the "locked" property for the dropdown is set to "no." If
> that's not it, I would check to see if you can edit other fields on the subform,
> and if the form's record source is updateable.
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , mithomas48 <no_reply@>
> wrote:
> > > > > >
> > > > > > I have a subform set as "Continuous" view, and a drop down (dd) in the
> detail section. The dd will display the rowsource fine, but will not allow a
> selection of any of the items listed. It acts like its in read only mode or
> something. The dd's control source is set to the field in the table. The subform
> is set to allow edits.
> > > > > >
> > > > > > Does anyone know why an item cannot be selected from the drop down?
> > > > > >
> > > > > > Thanks in advance!
> > > > > > Mike
> > > > > >
> > > > >
> > > >
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar