Cannot Stop Blank Forms!!

[123James]

Hi guys,

I have created a form based on a query that prompts the user to enter a persons name. Once entered, the persons data appears on the form and some other related data appears in a subform. However, I have found a problem that occurs when a name is entered that doesnt exist on the database... the form opens completely blank!! even text and graphics disappear!

Is there a way of stopping this from happening??

Thanks, James

 

[Oldsoftboss]

The form properties have the AllowAdditions set to NO.

You need to trap the query count before the form opens, and if no results, display message and leave the form closed.

Dave

 

[Rich]

If you used a combo box to enter/view names then the problem wouldn't occur in the first place