LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 96
Default keeping form open

On my form, there is a "submit" button. When the user
enters the data, they push the "submit" button.

This kicks off a routine to write the data they entered.
It also has an edit to make sure the amount (one text box)
on the form is not greater than the current balance (of
another field.)

If the amount is less than or equal to the current balance
than there is no problem.

However, if the amount is greater than the current
balance, I do not want to write the data and I want to
leave the form open so the user can make a correct and hit
the "submit" button again.

Not sure how to do this. Should I make the amount vs.
current balance a separate routine within the routine
kicked off by the "submit" button? Any help or examples
would be greatly appreciated.....Thanks for the help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save copy on Open, keeping old backup copies txheart Excel Discussion (Misc queries) 5 January 4th 12 08:32 PM
Keeping program open even when closing workbook Bob Excel Discussion (Misc queries) 3 April 25th 08 07:55 PM
Using a template form, advance a form number everytime you open ShoDan Excel Discussion (Misc queries) 1 January 31st 08 01:34 PM
Keeping 2 Excel workbooks open at the same time Royal Excel Discussion (Misc queries) 2 April 18th 05 10:10 PM
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? Daniel[_14_] Excel Programming 1 August 29th 04 01:20 PM


All times are GMT +1. The time now is 08:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"