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