John,
The Record source of the form is blank - nothing.
The Event procedure for the 'On Open'
Set db = currentdb()
Set ts = db.Openrecordset(strSQLSelect)
Me.Form.Recordsource = strSQLSelect
Thomas
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Thomas-
>
>
>
> It would help to see the Record Source of the form (the SQL if a query) and the
> code that's applying the filter.
>
>
>
> 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 Thomas
> Sent: Wednesday, July 04, 2012 6:45 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Recordset is not updatable
>
>
>
>
>
> The form shows this message when I attempt to update a field.
>
> In the 'Open' event, the VBA retrieves records based on criteria defined in the
> 'where' clause.
>
> The form displays the record(s) retrieve. However, one of the field was defined
> as a combo box which the user is able to select a value from the drop down.
>
> Any ideas how I can make it updatable?
>
> Thanks,
> Thomas
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar