Dear all,
Thanks for keeping this wonderful forum going.
I am having a problem with my application which I have developed using MS Access.
I have a form which I use to enter workorder information which is not bound to the workorder table, I am using VBA t save data into the table.
I have another form with a sub form. These are bound to to tables Workorder and WorkMaterial.
It is used to display Work Order Information while the subform is used to enter and displays material used for that particular Work order.
While entering a new workorder everything is fine.
After finishing entering a new work information. I am supposed to search that particular workorder using a combo box in the other form , and then use the sub form to enter material used for that work order.
The problem is that the combo box will show the new work order ID, But when selected it does not display the information. Till when you close the form and open it again. ( this is for new workorders only)
I have tried me.refresh but it doesn’t work.
Any help will be highly appreciated,
With best regards
Adelatus.