View Single Post
  #7 (permalink)  
Old April 26th, 2007, 11:04 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Since you are not using a combo box (standard) then you will have to check to make sure the data entered is numeric.

You can check to see if the record exists before you open the form. Forms do not have an On No Data event.

A combo box (with autocomplete functions!) would eliminate the need for all this.

mmcdonal
Reply With Quote