Hey
I'm currently in the process of building a rental database. I have a form with the purpose of checking in a returned rental. On this form is a Textbox which stores the issue date, and another which the user enters the return date. I want to have a textbox which from a button press, will display the cost of the rental, by determining the amount of days between the two dates stored in those text boxes, and multiplying that number of days by a daily rental charge.
I have experimented with methods including dateDiff in VBA on the click event for the Calculate button, but am having trouble getting the values from the text boxes to operate on. Any help would much appreciated.
Thanks, James.