I have a form that displays a list box with all of the IT Property Checkouts (orders) and when a user clicks the list box, it displays the order details in a subform.
The subform has two combo boxes, the first being AssetCategoryID and the second being AssetID. I have in the AssetCategoryID afterupdate event and the FormCurrent event a bit of code that filters the selections for the AssetID to the current AssetCategory. My problem is this; The AssetID field filters properly at all times, but if their is more than one item in the details table the data for the field does't appear until I click on it and it disappears if I click on another field (but it's still phsycially in the DB).
I have attached two zipped screen shots of the same record to show you what I mean.
The subform has two combo boxes, the first being AssetCategoryID and the second being AssetID. I have in the AssetCategoryID afterupdate event and the FormCurrent event a bit of code that filters the selections for the AssetID to the current AssetCategory. My problem is this; The AssetID field filters properly at all times, but if their is more than one item in the details table the data for the field does't appear until I click on it and it disappears if I click on another field (but it's still phsycially in the DB).
I have attached two zipped screen shots of the same record to show you what I mean.
