Microsoft form help

[jthorne]

Here's the final operation that I am trying to obtain with this form. It is a build record for the product that we build. We have a build record table which has all of our builds recorded, and in each column of this table has a different test and the value that was recorded. There is also a specification table, with the specifications for each different model (each model runs the same test just with a different specification. I need the form to have a drop down search that auto populates the specification fields, and allows the user to enter the values into the build record fields so that it can write to the table. Any help offered is greatly appreciate

[ItsMe]

You could apply a filter to the form's recordset or adjust the form's Recordsource property based on the value of the combo. I would use the Afterupdate event of the combobox control to fire the code.

[jthorne]

I have tried that but the problem that I am running into is it will not let me input information into the build record tables.

[ItsMe]

Not sure what that means. When you say, "...it will not let me input information..", you certainly are not refering to Access, in general. You need to use a recordset that is updateable.

When you create a form to edit records, make sure the query the form is based on is updateable.

[jthorne]

Sorry I am still very new to the program. Basically the forms job is to pull a record from the Specification table, and strictly display it using a drop down search bar. The "Build Record" table is there so that the user can add a record to the table. The query that this form is based on is updateable, it just will not allow me to edit/enter a new record to the "Build Record" tables fields in the form. I am just unable to find the problem and I hope I did a better job of explaining the problem that way

[ItsMe]

Sounds like the issue is that you are not using forms to, exclusively, enter and view data. Of course, reports work well for viewing data too. Bottom line, you should not use tables and or queries as a method for data entry and or viewing data.

Include your table named, "Build Record", in a form's recordset to allow for adding/editing.

[jthorne]

No I am using a form. I used the include existing properties field. When I was referring to the "Build Record" table, I was referring to them being imported into the form. Sorry if I am still confusing you.

[ItsMe]

Nothing here is making any sense to me.

I don't know what "include existing properties field" is

I am not aware that this is even possible
"being imported into the form"

Considering post #5 ONLY, try building a new form using the "Form Design" button in the Ribbon. Use your updatable query object as the new form's recordsource. Add a few fields to the form by dragging them from the "Field List" using the "Add Existing Fields" button.

Save your form and open it in "Form View". See if you can edit records.

[jthorne]

Okay, sorry about the confusion. Thank you for the help I appreciate it.