I have 3 issues with the form enclosed, 2 of them are related to the updation of unbound text boxes. Would appreciate some help.
1)
I have several unbound text boxes in a form. The values are updated in these text boxes using the column function of cbo boxes 'Country' and 'ConsigneeCode'. However when the form is reopened, the text boxes are blank.
If I refresh the cbo value, the text boxes are updated.
I tried requery of these fields in form load event, it did not work. How can it be done. The attached DB has only one form in question.
If it cannot be triggered by opening of the form, is there some command button which can be added to update all records?
2)
I have added a Dateadd function to get Exptd Delivery Date. There is an unbound text box I am using for this - Transit. This unbound text box is again updated with cbo Consignee code field. However this resultant value ExptdDelyDate is updated when form is reopened, unlike the above text boxes. However it is not refreshed unless form is closed and reopened!
Me.ExptdDelyDate = DateAdd("d", [Transit], [ExptdSailingDate])
3)
The Booking Ref uses a counter which is concatenated using a counter (unbound text boxes are hidden). Can we get a dynamic set of leading zeroes in the reference number e.g 0001, 0012, 0987, 9821 etc
1)
I have several unbound text boxes in a form. The values are updated in these text boxes using the column function of cbo boxes 'Country' and 'ConsigneeCode'. However when the form is reopened, the text boxes are blank.
If I refresh the cbo value, the text boxes are updated.
I tried requery of these fields in form load event, it did not work. How can it be done. The attached DB has only one form in question.
If it cannot be triggered by opening of the form, is there some command button which can be added to update all records?
2)
I have added a Dateadd function to get Exptd Delivery Date. There is an unbound text box I am using for this - Transit. This unbound text box is again updated with cbo Consignee code field. However this resultant value ExptdDelyDate is updated when form is reopened, unlike the above text boxes. However it is not refreshed unless form is closed and reopened!
Me.ExptdDelyDate = DateAdd("d", [Transit], [ExptdSailingDate])
3)
The Booking Ref uses a counter which is concatenated using a counter (unbound text boxes are hidden). Can we get a dynamic set of leading zeroes in the reference number e.g 0001, 0012, 0987, 9821 etc