Not sure why, but not all of my replies are posting. I did send a following up that didn't post saying the query is updateable (if I debug.print the Select to a query object). No, the subform is not linked to the parent. I am using a standard module to load the RecordSource of the parent and subform. I pull the unique ID from the parent and use it for the standard module to load the subform. I don't want to bind the table to the form.
Thanks in advance!
Mike
--- In MS_Access_Professionals@yahoogroups.com, "sarmbraugh" <sarmbraugh@...> wrote:
>
> None of the fields in the subform can be changed, is that right?
>
> Is your subform linked to the parent form? You can check this in the data tab on the property sheet for the subform - "Link Master Fields"/"Link Child Fields").
>
> One way to see if the record source is updateable is to view the record source in data sheet view and see if you can add to it. You should see an empty row at the bottom with an asterisk next to it where you can add an item.
>
> --- 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