Notification in access?

[Xterra14s]

What I want to do is have the circled field in the attachment I posted have certain notification appear based on the selection from the machines and supplies drop down. For example, if said machine is allowed to be ordered once every three months and the last order date was 2 months ago I want it to display the last ordered date in red like a notification. If its after three months then the field is left blank. Is this possible? I feel like IIF statements might help. For example, if said machine is selected and the last date is less than 90 days display message "Machine was ordered less than 3 months ago". The goal of this is to keep the end user from ordering patient equipment before their due date.

[ranman256]

this box will be a subform.
create a query to produce the messages you want. It will calculate the time and the message.
the subform will show this result.

[Micron]

Is that control bound to anything (I think not)? If so, you can't enter an expression into it. If not, what is it? A textbox? If so, you'll need a combination of a DMax expression and Conditional Formatting. You can't enter a sql statement as a control source for a textbox, but you can use DMax with an expression that returns the last date value, or nothing if nothing satisfies the criteria part of the lookup. See the use of DMax here http://www.techonthenet.com/access/f...omain/dmax.php

Once you have that, use conditional formatting to format the colors you want for the textbox background or font. Will any of this keep the user from ordering anything that shows up in red, or does it really just warn someone who may order it anyway? I see by your posted image that you use spaces in your field names (bad practice). Maybe you should take a look at some db object naming recommendations.
http://www.access-programmers.co.uk/...d.php?t=225837
http://access.mvps.org/access/general/gen0012.htm
http://allenbrowne.com/AppIssueBadWord.html

[ssanfu]

And there is a field that begins with a number (911). The Access gnomes can get touchy when objects begin with a number - ALWAYS begin object names with letters.