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, "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, 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, 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, "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, 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
> > > > >
> > > >
> > >
> >
>
Tidak ada komentar:
Posting Komentar