By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,680 Members | 1,436 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,680 IT Pros & Developers. It's quick & easy.

Urgent - non-editable fields in form

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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" <cu*******************@yahoo.com> wrote in message
news:84**************************@posting.google.c om...
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

Nov 12 '05 #2

P: n/a
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" <wi*****@covad.net> wrote in message news:<18**************************@msgid.meganewss ervers.com>...
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" <cu*******************@yahoo.com> wrote in message
news:84**************************@posting.google.c om...
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

Nov 12 '05 #3

P: n/a
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.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.