D
Dino
I need some generic code for handling the case where an account is not found.
I have tried a few responses from previous postings, but nothing has worked
so far. My simplified scenario is this: I have a table called "accounts", and
the fields are accountnumber, accountname, and amountdue. I have a second
table named "paystatus", with "accountnumber" and "paidamount" as it's fields.
When a user enters the account number in the form, I need a message box to
pop up if there is no matching accountnumber in the accounts table. Right
now, a blank screen comes up. Right now the tables are joined by an inner
join.
Dino
I have tried a few responses from previous postings, but nothing has worked
so far. My simplified scenario is this: I have a table called "accounts", and
the fields are accountnumber, accountname, and amountdue. I have a second
table named "paystatus", with "accountnumber" and "paidamount" as it's fields.
When a user enters the account number in the form, I need a message box to
pop up if there is no matching accountnumber in the accounts table. Right
now, a blank screen comes up. Right now the tables are joined by an inner
join.
Dino