Filling a textbox with the answer to an operation involving values from other text boxes

[JJAMII]

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.

[pbaldy]

Have you tried

Me.TextboxName

presuming the code is on the same form.

[JJAMII]

With a little bit of playing around i've managed to solve it, thanks though!

[pbaldy]

Posting your solution could help later forum users.

[JJAMII]

Ah yeah good shout. Well haven't got a complete solution but it's easy from here on out.

Dim firstDate As Date, secondDate As Date, difference As Integer


firstDate = DateValue(Me.FirstdateTextBox)
secondDate = DateValue(Me.SecondDateTextBox)


difference = dateDiff("d", firstDate, secondDate)


Me.DifferenceTextbox = difference


That displays the difference between the two dates in a text box for me. All i need to do now is add a sum for difference x 'dailycharge' and i'm sorted.