Hi,
I have a form that shows rental information, a person can rent an item for either 1 week or 2 weeks. Is there any way that the background of a control can be changed ('ReturnDate', which would have no entry at this stage)when the rentals period has expired. The form has amongst other details a field that displays the rental period (1 week or 2 weeks) and also a field indicating the Rental Date. I have a query that shows outstanding rentals, but would like the user to be shown if a rental has exceeded either the 1 or 2 week period.
Ken
I have a form that shows rental information, a person can rent an item for either 1 week or 2 weeks. Is there any way that the background of a control can be changed ('ReturnDate', which would have no entry at this stage)when the rentals period has expired. The form has amongst other details a field that displays the rental period (1 week or 2 weeks) and also a field indicating the Rental Date. I have a query that shows outstanding rentals, but would like the user to be shown if a rental has exceeded either the 1 or 2 week period.
Ken
