K
kjss
Help! Nothing's locked. I can add info through the table, but the form only
shows one record and it won't allow me to edit.
shows one record and it won't allow me to edit.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Coleen
On your form, check the Properties under Data Entry. If this is set to Yes,
it will open the form for Data Entry only, and will not show you any but the
most current record that has been opened to enter data on. Change it to NO
and you should be able to see all your records. The only drawback to this
is that if your users go to do data entry and don't click on the Arrow* they
will be able to override data already entered. Just be sure your users know
what they are doing!
HTH,
Coleen
it will open the form for Data Entry only, and will not show you any but the
most current record that has been opened to enter data on. Change it to NO
and you should be able to see all your records. The only drawback to this
is that if your users go to do data entry and don't click on the Arrow* they
will be able to override data already entered. Just be sure your users know
what they are doing!
HTH,
Coleen
K
kjss
Thanks for your response...I tried the Data Entry and it only showed me what
was entered, but I still couldn't edit within the form. After deleting all
of the entries in the table, I tried to go back to the form again. This time,
I was able to enter, but it wasn't saving any of the info in the form.
was entered, but I still couldn't edit within the form. After deleting all
of the entries in the table, I tried to go back to the form again. This time,
I was able to enter, but it wasn't saving any of the info in the form.
K
kjss
Everything updates in the table, but not in the form...I'm not sure whether
or not I expressed that before.
or not I expressed that before.
Thanks for your response...I tried the Data Entry and it only showed me what
was entered, but I still couldn't edit within the form. After deleting all
of the entries in the table, I tried to go back to the form again. This time,
I was able to enter, but it wasn't saving any of the info in the form.
[quoted text clipped - 9 lines]On your form, check the Properties under Data Entry. If this is set to Yes,
it will open the form for Data Entry only, and will not show you any but the
C
Coleen
Is your form bound to a table or a query? Sometimes if you have it bound to
a query with multiple table relationships the form won't allow updates.
Coleen
a query with multiple table relationships the form won't allow updates.
Coleen
kjss said:Everything updates in the table, but not in the form...I'm not sure whether
or not I expressed that before.
Thanks for your response...I tried the Data Entry and it only showed me what
was entered, but I still couldn't edit within the form. After deleting all
of the entries in the table, I tried to go back to the form again. This time,
I was able to enter, but it wasn't saving any of the info in the form.
theOn your form, check the Properties under Data Entry. If this is set to Yes,
it will open the form for Data Entry only, and will not show you any but
[quoted text clipped - 9 lines]Help! Nothing's locked. I can add info through the table, but the form only
shows one record and it won't allow me to edit.
C
Coleen
Did you set your Allow Edits to Yes in the properties of your form?
kjss said:Everything updates in the table, but not in the form...I'm not sure whether
or not I expressed that before.
Thanks for your response...I tried the Data Entry and it only showed me what
was entered, but I still couldn't edit within the form. After deleting all
of the entries in the table, I tried to go back to the form again. This time,
I was able to enter, but it wasn't saving any of the info in the form.
theOn your form, check the Properties under Data Entry. If this is set to Yes,
it will open the form for Data Entry only, and will not show you any but
[quoted text clipped - 9 lines]Help! Nothing's locked. I can add info through the table, but the form only
shows one record and it won't allow me to edit.
K
kjss
It is bound to a multiple relationship table.
Is your form bound to a table or a query? Sometimes if you have it bound to
a query with multiple table relationships the form won't allow updates.
Coleen
[quoted text clipped - 9 lines]Everything updates in the table, but not in the form...I'm not sure whether
or not I expressed that before.
K
kjss
Yep...everything is set to "yes."
Did you set your Allow Edits to Yes in the properties of your form?
[quoted text clipped - 9 lines]Everything updates in the table, but not in the form...I'm not sure whether
or not I expressed that before.
C
Coleen
I had the same problem with one of my forms. It was bound to three related
tables and I could not get it to update. This happens sometimes when you
have more than one table on the form. The usual way around it is to create
a subform in your form that is bound to the other table(s).
For some reason I could not get the parent/child relationship on my subform
to work correctly. I ended up using the form wizard and letting it "Create"
a select statement for me, which now my form is bound to without using any
subforms.
I normally am not a proponent of using wizards to get things to work, but in
this case, it worked and all I did was to format my form and write a bit of
code to do some conditional formatting.
Try re-creating your form using the wizard and then reformatting it to look
like you want it to.
I can't tell you why sometimes it works, sometimes it doesn't - quite
frankly I don't know. Maybe a MS Access Exec will read this and answer.
Sorry I couldn't be more helpful, but please let me know if using the wizard
doesn't work and I will try to help.
Coleen
tables and I could not get it to update. This happens sometimes when you
have more than one table on the form. The usual way around it is to create
a subform in your form that is bound to the other table(s).
For some reason I could not get the parent/child relationship on my subform
to work correctly. I ended up using the form wizard and letting it "Create"
a select statement for me, which now my form is bound to without using any
subforms.
I normally am not a proponent of using wizards to get things to work, but in
this case, it worked and all I did was to format my form and write a bit of
code to do some conditional formatting.
Try re-creating your form using the wizard and then reformatting it to look
like you want it to.
I can't tell you why sometimes it works, sometimes it doesn't - quite
frankly I don't know. Maybe a MS Access Exec will read this and answer.
Sorry I couldn't be more helpful, but please let me know if using the wizard
doesn't work and I will try to help.
Coleen
kjss said:It is bound to a multiple relationship table.
Is your form bound to a table or a query? Sometimes if you have it bound to
a query with multiple table relationships the form won't allow updates.
Coleen
[quoted text clipped - 9 lines]Everything updates in the table, but not in the form...I'm not sure whether
or not I expressed that before.Help! Nothing's locked. I can add info through the table, but the form only
shows one record and it won't allow me to edit.
K
kjss
Thanks for taking time out to respond. I'll give it a shot.
I had the same problem with one of my forms. It was bound to three related
tables and I could not get it to update. This happens sometimes when you
have more than one table on the form. The usual way around it is to create
a subform in your form that is bound to the other table(s).
For some reason I could not get the parent/child relationship on my subform
to work correctly. I ended up using the form wizard and letting it "Create"
a select statement for me, which now my form is bound to without using any
subforms.
I normally am not a proponent of using wizards to get things to work, but in
this case, it worked and all I did was to format my form and write a bit of
code to do some conditional formatting.
Try re-creating your form using the wizard and then reformatting it to look
like you want it to.
I can't tell you why sometimes it works, sometimes it doesn't - quite
frankly I don't know. Maybe a MS Access Exec will read this and answer.
Sorry I couldn't be more helpful, but please let me know if using the wizard
doesn't work and I will try to help.
Coleen
[quoted text clipped - 8 lines]It is bound to a multiple relationship table.