Greyed Out New Record Problem

[LadyScot101]

I created a database to input new employees in a uniform database. It's a New Employee Input Form, New Employee Input Query and Employee Information Table. The Form has drop down boxes that pull in information from a Location Table, Years Code Table, Position Table, and all tie to the Employee Info Table. They are Inner Joined to the Employee Info Table. There is no subform. It's a simple input form. Problem is, the add new record is greyed. The Addition and Data Entry is set to Yes and when I open the form, the data is there, which it shouldn't be. When I click on a drop down box of what is on the screen, there is nothing to choose. Everything in properties is set to yes, so I don't understand. I have no VBA code or anything attached to it. What could it be? I'm totally confused!

 

[billmeye]

If your form is based on a query pulling fields from multiple tables then Access may not consider the recordsource updatable. There may be a field that is ambiguous (same name in multiple tables) making it not possible for Access to know which table is being updated.

 

[LadyScot101]

The Years Code Table does have Years Code field name the same as in the Employee Info Table and Location in the Location Table is the same name as the Employee Info Table. I included those extra tables as pull-down data to choose from for the Form. How do I get the database to understand that the Employee Info Table is what is to be updated. I'm new at this. Can you tell?

 

[billmeye]

Would you like to attach your DB (if your able to) and I can better take a look.

I included those extra tables as pull-down data to choose from for the Form

On the surface, it sounds like you are talking about ComboBox row sources and not the forms record source. If you included those tables in the forms record source that is not needed. The forms record source really should be just a table, not a query.

 

[LadyScot101]

I've attached my Uniform Database. It's the New Employee Input Form that I am trying to get to work. The New Employee Input Query pulls the data and it's supposed to input into the Employee Info Table. Thanks bunches for the help!!!

 

[billmeye]

Take a look and you will see for each ComboBox the table that contains the drop down list is the row source. Your form has a table as the record source. This is how you will set up any additional forms and ComboBoxes. Good Luck.

 

[LadyScot101]

It works!!! It's so logical once you look at it. Thanks so much for the assist. Now my brain is unscrambled. LOL!

 

[billmeye]

Glad you understand. Good Luck with the rest of your project.