Custom msgbox buttons

[David]

Hi

Could someone please help with how to compile a module for
custom msgbox buttons?

Thanks
David

 

[Guest]

not sure what you mean by custom msgbox buttons but if you
mean custom messages...
1.create a table with all your custom messages with unique
record id (autonumber?)
2.create a form with label to display your custom
messages. on the form have a hidden textbox control whose
record sorce is a query that used the record id in the
control.
3. now the tricky part. in your code, set criteria to call
the appropreate custom message at the appropreate time
have the code open the message form with the appropreate
message.

 

[Guest]

after thoughts
on number 3.
Have your code put the unique message id of the message
you want displayed in the hidden text box
if contition 1 then
Me.hiddentextbox = 1
else
me.hiddentextbox = 2
end if
docmd.Open form "messages", acnormal
make sure the message form has a close button.
on number 2
on the message form, have the label's control source = the
query that uses the info in the hidden text box as
criteria. the hidden text box should not have a control
source.
label's control sorce.
SELECT [Messages].Message FROM Messages WHERE
((([messages].ID)=[Forms]![yourform]![hiddentextbox]))"
my mistake.