Access Forms-cannot enter data

[jalmar]

My question is related to Access forms. I have set up an Access form using 4 different tables~I am pulling 2 different numbers and the name of Trusts out of one table, I am pulling custodian name and acct number from 2nd table, 2 different numbers from Investment manager table and then 3 empty fields (at this time-needs to be populated by form) out of the 4th table. Can you tell me why I am not able to enter data into the 3 empty fields while in form view. All the tables I am using for the forms are updatable. Hope this is clear. Thanks in advance for your help.

[maxamis4]

Its the query your form is based on. For some reason it locks the record due to the criteria that you have setup. If you have relationships that are dependent on one another this could account for it.

Play with the query you are using to bind your form. Try two then add the third, then try a combination of the three to figure out where the problem is.

[jalmar]

Its the query your form is based on. For some reason it locks the record due to the criteria that you have setup. If you have relationships that are dependent on one another this could account for it.

Play with the query you are using to bind your form. Try two then add the third, then try a combination of the three to figure out where the problem is.

I am using tables to set up the form-no queries-there are queries ran off the tables in the database but I am not utilizing them for the form-will that still make a difference?

[maxamis4]

but i take you are using the control source to select multiple locations right? if so that is also a query, if not how are you binding the tables to the forms?

[jalmar]

but i take you are using the control source to select multiple locations right? if so that is also a query, if not how are you binding the tables to the forms?

I use the wizard and choose the tables in the beginning. So that is then a query?

[jalmar]

I use the wizard and choose the tables in the beginning. So that is then a query?

OK-I will go back and try as you say to break it down and find which table is causing the lock. I will get back with you-thanks for your time.

[maxamis4]

It sounds like it did one. Look at the form and click on the button with the three little dots and see what the control source is.

[jalmar]

It sounds like it did one. Look at the form and click on the button with the three little dots and see what the control source is.

I don't see three buttons to click on, on the actual form. I did go back and check and 2 of the tables aren't allowing to input, two of them are. I need to go back and check the 2 tables that aren't allowing, there are some changes I need to make to those. They were imported directly from Access and I just let Access set them up.

[AccessIdiot]

I think maxamis4 means that when you have the form open click on Design to look at it in Design view. Then on the last tab labeled "Data" the top one is the Record Source. That is the query that pulls the fields from the tables that you want on your form. Something in there might be causing the problem?

I am having the same problem with a form of mine and am trying to figure out why I can't type into a textbox.

Cheers,
melissa (the Access Idiot)

[MMcCarthy]

Hi Jalmar

You cannot base a form on a non-updatable query. A query is non updatable for a number of reasons but in your case I can make a guess at the cause.

You have based the form on 4 tables but this will only work if there is a one to one relationship between all those tables. That is there is one and only one record in each table corresponding to the record in another table.

For any tables that can hold many records relating to one record in another table you will have to set up a subform. Test out your form query separately in the quey window and you will see you can't add to it there either. This has nothing to do with the forms operation.

Mary

[maxamis4]

You got it right, thats what I meant, and the explaintion that the other guy just gave is perfect.

Let me know how the trouble shooting goes.

[jalmar]

Thank you all so much, I will take a look at that and let you know. This stuff is great.

[NeoPa]

You haven't actually said this anywhere, but would I be right to think that this form you are talking about actually manages the four different tables using multiple sub-forms based on the main form?
Let us know what the Record Sources are of your form(s).

[jalmar]

You haven't actually said this anywhere, but would I be right to think that this form you are talking about actually manages the four different tables using multiple sub-forms based on the main form?
Let us know what the Record Sources are of your form(s).

OK-I actually kept working with the information you guys have given and I have finally figured it out. I created a query and used one table and now have my subform working correctly to enter the data. Thanks for your help on this.

I still haven't figured out the problem with my Excel spreadsheet though. I linked the spreadsheet to Access, had it pulling the data in and updating correctly but when I run the query I get far too many duplicated records. Even when I import the data into Access and run the queries there are too many duplicated records. I believe Juan is working on this with me but haven't heard back from him today. Any help would be appreciated

[NeoPa]

Let's have a look at the SQL you're using then. Perhaps we can see where you're making any mistake.
BTW Who's Juan?