|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 24th, 2008, 06:08 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Design problem?
Is there a reason why a subform won't let you enter new data? I can enter new
data in the main form section just fine. The subform does have the dropdown list that displays the correct choices, but when I click on one of them, nothing is entered in the field. Essentially, the subform only displays the existing data but won't let you enter new records. The tables ARE related, so it's not a relationship issue. any thoughts? Thanks for your help! Pat 
|
|
#2
November 24th, 2008, 06:14 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Design problem?
On Mon, 24 Nov 2008 10:08:01 -0800, Patttt wrote:
Is there a reason why a subform won't let you enter new data? I can enter new data in the main form section just fine. The subform does have the dropdown list that displays the correct choices, but when I click on one of them, nothing is entered in the field. Essentially, the subform only displays the existing data but won't let you enter new records. The tables ARE related, so it's not a relationship issue. any thoughts? Thanks for your help! Pat Either your form does not allow edits/inserts or the RecordSource it is bound to does not. Are you using a query for the form's RecordSource? Many queries are read only. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#3
November 24th, 2008, 06:44 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Design problem?
I didn't write the original database but am trying to correct a number of
problems in it. As far as I can tell, the form is based on a query that is based on a table. :} I drilled down and learned that I can enter a new record in the table but not in the query. "Rick Brandt" wrote: On Mon, 24 Nov 2008 10:08:01 -0800, Patttt wrote: Is there a reason why a subform won't let you enter new data? I can enter new data in the main form section just fine. The subform does have the dropdown list that displays the correct choices, but when I click on one of them, nothing is entered in the field. Essentially, the subform only displays the existing data but won't let you enter new records. The tables ARE related, so it's not a relationship issue. any thoughts? Thanks for your help! Pat Either your form does not allow edits/inserts or the RecordSource it is bound to does not. Are you using a query for the form's RecordSource? Many queries are read only. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#4
November 24th, 2008, 08:04 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Design problem?
BTW - How do I tell if the query is read only? I don't see anything about it
in the properties section........ thanks! "Rick Brandt" wrote: On Mon, 24 Nov 2008 10:08:01 -0800, Patttt wrote: Is there a reason why a subform won't let you enter new data? I can enter new data in the main form section just fine. The subform does have the dropdown list that displays the correct choices, but when I click on one of them, nothing is entered in the field. Essentially, the subform only displays the existing data but won't let you enter new records. The tables ARE related, so it's not a relationship issue. any thoughts? Thanks for your help! Pat Either your form does not allow edits/inserts or the RecordSource it is bound to does not. Are you using a query for the form's RecordSource? Many queries are read only. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
