Using MsgBox in a Macro

[snagrat]

I have a command button so when it is clicked it runs a macro which at the moment only sets the visible values to either true or false.

Now I have added a MsgBox to the top of the macro so that when it is click a MsgBox is displayed with text. However I want part of the text to be read from a txt box on my from.

i.e. An item is out on loan and is renewed. When the Renew button is click the MsgBox pops up reading "Item renewed. New return date is [txtDueBackFromLoan].

Anyone know how to do it? And is it possible?

 

[snagrat]

Thinking about it, it is probably easier to do it using code isn't it?

I will give that a try

 

[David R]

Cheers for trying VBA and good luck. Try having Access convert over some of your old macros to code to see what the differences are. They aren't as wild as you might think, and code gives you so much more flexibility.

David R

 

[snagrat]

Wot?

I have sorted it now any way

I just used code to do most of it

 

[varunmathur]

Hi
I had a similar problem;
I used a form to show the desired message and closed the form either with the timer or command button
varun