Combo Box Issues

[Beanochini]

I am in process of building my 1st Database and do not have much experience. The database is for credit card expenses and has credit card name, date, amount, currency and calculated field for GBP equivalent. I have also put in two Combo boxes. one For Main expense Category and another for a Sub Category. There are three Tables (Category, Subcategory and main expenses table). The form picks up from the main expenses table and the combo boxes are populated from Category and Sub Category tables. A query is used as the Row source for the Subcategory to filter for these depending on the Category. I have also put in an event :



Private Sub CboCategoryP_AfterUpdate()
Me.CboSubCatP.Requery
Me.CboSubCatP.Value = ""


End Sub

The form writes the Value for category and Subcategory in the main Expenses table.

It all seemed to work but although the value is written to the main table it is not displayed in the form (except when I input using the selection dropdown for the category and subcategory) If I move to the next record and then come back, the category and subcategory are either blank or have different values in them

As a novice I am must be doing something wrong- any help would be appreciated. Driving me bonkers - and so far spent 3 days trying to sort it! Access 2016, Window 10 64

Cheers
Beanochini

[ranman256]

Me.CboSubCatP= null

Me.CboSubCatP.Requery

PROVIDING the CboSubCatP query looks at combo1:

select SubCat from tCatagory where [cat] = forms!myform!CboCategoryP

[Beanochini]

Thanks. Not sure I understand the last bit

The three tables are MainExpensesT (this has the Combobox], CategoryPT (has list of Primaery Categories and of course the autonumber as the key) and the MainSubCatT (has Sub Categories list, Autonumber key, CategoryP as a long integer number (foreign key)) the query is run on the MainSubCatT, and the criteria is [Forms]![MainExpF]![CboCategoryP] (this is titled MainSubCatQ) and becomes the Row source. Is there a problem with this? Thanks in anticipation!

[Beanochini]

The above worked well when I tried it out as a stand-alone test. It delivered the appropriate Sub Categories to the second combo box. It does so now too... and the Main expenses form (MainExpF) stores the correct value in the MainExpensesT but as soon as I move to the next record the form losses the original values but the Table retains the correct value.
Cheers