I don't think that it's practical to store payment information in an
Access (Jet) database.

It's just not possible to secure a jet database

Move to SQL Server if you want to keep your data secure. I really
reccomend Access Data Projects, they allow you to use Access forms and
reports.. and additionally seamlessly use Stored Procedures, Views,
Functions, Triggers, etc






On May 25, 9:34*am, Bardia wrote:
Access 2003 form with several controls including following:
1- Payment Type (combo box) that contain three entrees: CASH, Check, Credit
Card
2- Check Number (text box)
*Question:
What procedure or code I have to apply and to which event in property of
Check Number Control that if user chose the Check in Payment Type combo box
to be forced to enter a check number into Check Number control before record
could be saved?

--
Bardia