Not all fields are writing to db from form

[aytee111]

Yes, that is the correct way (posts crossed).

[PinkLady50]

Thanks for your help on all of this. I reread through this again today and I do need to capture the Category on the Problem_Record tbl in addition to the CategoryID.
As you can see from the form I sent, the managers are using the actual Category as a field to view on the datasheet portion of the form. CategoryID is captured but not displayed on the form. If I am only capturing the CategoryID then the Problem_Record tbl would not have the corresponding text description of the Category.

I hope this makes sense.

I tried to create an After_Update event but I can't get it to pull the Category correctly.
I keep getting a 6 (CategoryID) in the Category not the description.

I have this running on the Category field of the Input form where the field is pulling CategoryID in the combobx.

Private Sub Category_AfterUpdate()
Me!Category = Me!Category.Column(1)
End Sub

[aytee111]

Did you add Category as a new field to the form?

[PinkLady50]

I deleted it yesterday when you told me to take it out of the Problem_Record tbl. As you can see from the form I added back to the tbl and form so it would be viewable. I have now populated it with categories to match the problem.

[PinkLady50]

Here is my latest Relationship view

[aytee111]

The form in #17 should be a query with the category (etc) tables joined.

[PinkLady50]

I am sorry, could you clarify "form in #17"

[aytee111]

The record source for that form, the one in post #17, should be a query.

[PinkLady50]

Inner Join or Outer Join?

[aytee111]

The query would match your relationships view. It doesn't look like there are any outer joins in your relationships.