Sure there's a simple answer to this but I can't get my head aroun

  • Thread starter Thread starter RitchieJHicks
  • Start date Start date
R

RitchieJHicks

I would like to have an "announcements" memo field in my database. This would
show a message for example such as "Please note that all staff can go home 2
hours early today" (yeah, right).

I want managers to be able to edit this text in a simple seperate form. It
needs to display the SAME message on all of my records.

I have set up a new table called Management but I can't seem to link it to
my existing form.

Help please!
 
A form can have only one record source.
One way would be to have a subform on every form that would show the record,
but that is pretty cluzty.

A better way to do this is to create a form that opens when your app starts
up that is hidden. That form should have the table that has the message in
it as it's record source.
Now, use the form's timer event to periodically check to see if there is a
new message to display. If there is, open the form in Popup mode to display
the message. The popup mode will cause it to come up on top of all other
forms.
 
Back
Top