Urgent - non-editable fields in form

Hi,

I created two forms using forms wizard. One was for a master table
that has just an ID and Description column. Another was for a
transaction table that has foreign keys from the master table and its
own description fields.

In the master form, I can create and edit records succesfully.
In the second one, when I create a new record, the form doesn't let me
edit the description fields. I can edit the foreign key fields. I have
to first save the half-baked record with only the foreign key fields
in it and then come back and edit the description fields.

Any pointers as to what could be the problem? Both the forms have the
properties set same. I have Allow additions = Yes and DataEntry =No.
For the controls, I have enabled = Yes and Locked=No.

I am a newbie with forms and i don't know VB. Any pointers would be
helpful.

Thanks,
YS

re: Urgent - non-editable fields in form

Do you have two separate forms? If so, drag the second form (transaction
table) from the
database window onto the primary form (opened in design view) for the master
table - thus creating a subform. Access should recognize the
primary/foreign key relationship and set up the appropriate relationship
between the forms and their respective tables.

HTH

"Young Seeker" <cutelittleyoungseeker@yahoo.com> wrote in message
news:840b9a17.0401181223.65121291@posting.google.c om...[color=blue]
> Hi,
>
> I created two forms using forms wizard. One was for a master table
> that has just an ID and Description column. Another was for a
> transaction table that has foreign keys from the master table and its
> own description fields.
>
> In the master form, I can create and edit records succesfully.
> In the second one, when I create a new record, the form doesn't let me
> edit the description fields. I can edit the foreign key fields. I have
> to first save the half-baked record with only the foreign key fields
> in it and then come back and edit the description fields.
>
> Any pointers as to what could be the problem? Both the forms have the
> properties set same. I have Allow additions = Yes and DataEntry =No.
> For the controls, I have enabled = Yes and Locked=No.
>
> I am a newbie with forms and i don't know VB. Any pointers would be
> helpful.
>
> Thanks,
> YS[/color]

re: Urgent - non-editable fields in form

Hi,

Thanks for the reply.

But I don't think that's what I am looking for.

I have a the following tables:
Contact(ContactID, FirstName, LastName)
TaskList(Date, ContactID, Description)

I want to make a data entry form for TaskList. For this I went to the
wizard and pulled Contact.FirstName, Contact.LastName and
TaskList.Date, TaskList.Description. I have no problem with the
foreign key. But my form doesn't allow me to edit the Description
field, which is not a foreign field. I checked the properties and the
field is enabled and it is bound to the right field in the table.

Regards,
Young Seeker

"Squirrel" <wiseowl@covad.net> wrote in message news:<18761$400b935e$44a56575$8443@msgid.meganewss ervers.com>...[color=blue]
> Do you have two separate forms? If so, drag the second form (transaction
> table) from the
> database window onto the primary form (opened in design view) for the master
> table - thus creating a subform. Access should recognize the
> primary/foreign key relationship and set up the appropriate relationship
> between the forms and their respective tables.
>
> HTH
>
> "Young Seeker" <cutelittleyoungseeker@yahoo.com> wrote in message
> news:840b9a17.0401181223.65121291@posting.google.c om...[color=green]
> > Hi,
> >
> > I created two forms using forms wizard. One was for a master table
> > that has just an ID and Description column. Another was for a
> > transaction table that has foreign keys from the master table and its
> > own description fields.
> >
> > In the master form, I can create and edit records succesfully.
> > In the second one, when I create a new record, the form doesn't let me
> > edit the description fields. I can edit the foreign key fields. I have
> > to first save the half-baked record with only the foreign key fields
> > in it and then come back and edit the description fields.
> >
> > Any pointers as to what could be the problem? Both the forms have the
> > properties set same. I have Allow additions = Yes and DataEntry =No.
> > For the controls, I have enabled = Yes and Locked=No.
> >
> > I am a newbie with forms and i don't know VB. Any pointers would be
> > helpful.
> >
> > Thanks,
> > YS[/color][/color]

re: Urgent - non-editable fields in form

YS,
did you create the relationship between the two tables before trying
to add records? TaskList.ContactID should be a long integer. If you
do that, the data entry should work fine.