I have form1 that needs rental credit data. I have a button to open form2 to calculate the rental credit. When I have entered the details and have calculated the rental I would like to create a button that will allow me to send the calculated rental credit back to the Rental Credit field in form1.
Currently when I try:
DoCmd.OpenForm "form1"
[Forms]![form2]![RentalCredits] = Me.RentalCredits
Or
Me.RentalCredits = [forms]![form1]!RentalCredits]
I get "You can't assign a value to this object"