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