Hi All,
I have attached a small database (Access 2003). This has table to show customer details and order details.
It also has 3 forms and 2 subforms. The forms are as follows
frmAddNewCustomer is to input new customer
frmAddNewOrderDetails is to input new orderlines by customers
frmShowAllByCustNo which show the customers and the orders
In the table "tblCustInfo" I have three customers at present
ID IDNumber Surname GivenNames
1 2012001 Prabhu Raghu
2 2012002 Jain Sanjay
3 2012003 Kamath Sunil
In the table "tblPurOrder" I have the following data.
ID tblCustInfoID PurOrderNo purDate
1 1 201206001 1/06/2012
2 1 201206002 1/06/2012
3 2 201206003 1/06/2012
4 2 201206004 1/06/2012
when I open form frmShowAllByCustNo it prompts the user for the customer number. If I input 2012001 or 2012002 order lines will show.
If I input 2012003 there are no records to show.
My first question is
How do I make a message box popup and give the message "This customer does not have and order lines" and then the form "frmAddNewOrderDetails " popup when customer number 2012003 is input?
My second question is {Removed - Please check the rules}
Thanks
Raghu Prabhu