Tupacmoche
Registered User.
- Local time
- Today, 07:25
- Joined
- Apr 28, 2008
- Messages
- 291
Hi Form Masters,
I have a form that has several payment methods that all go into a single backend database field called Amount. If a person pays by check the textbox is called txtcheck, if by cash it is txtCash ect there is textboxes wire, credit card and others. But, they all are bound to an SQL field called Amount. Before a form is closed I have to check that if Amount is over 100K another form was filled out. I want to avoid having to check six or more fields that are really referring to one column in the database. But when, I tried this:
If Nz(dbo_myTable.Amount) >= 100000 Then
MsgBox ("You must fill out a StewardShip form to continue...")
Else
End If
I get run-time error 424 object required. When I replace the table field name with an Access textbox that holds the value it works. But now I have to check every textbox. Is there an easier way?
I have a form that has several payment methods that all go into a single backend database field called Amount. If a person pays by check the textbox is called txtcheck, if by cash it is txtCash ect there is textboxes wire, credit card and others. But, they all are bound to an SQL field called Amount. Before a form is closed I have to check that if Amount is over 100K another form was filled out. I want to avoid having to check six or more fields that are really referring to one column in the database. But when, I tried this:
If Nz(dbo_myTable.Amount) >= 100000 Then
MsgBox ("You must fill out a StewardShip form to continue...")
Else
End If
I get run-time error 424 object required. When I replace the table field name with an Access textbox that holds the value it works. But now I have to check every textbox. Is there an easier way?