POP UP Messages.....

[daherb]

Does anyone know if it is possible to add a pop-up message to an individual record in a database? and if so how do you do it???

I have a database which holds infomration about suppliers, some suppliers give us fixed prices for some products to general customers but they also offer another price for certain customers of ours. What i want to do is have a pop up message displayed to users that pull up these products with varying prices..

Anyone got any ideas???????????????????

 

[neileg]

I would:
1 Hold all my prices in a table, including the specials, and set a flag on the special prices
2 Base my normal viewing form on a query that selects only those prices that are not flagged as specials
3 Have a second form that is triggered by an event on the main form that pulls its data in a query from the prices that are flagged as specials. This event could be a form event or a command button