Force Check Number entry

[Hank]

To post payments recieved, I have a form based on a payment query. The "How
Paid" section is a combo box with "Cash" "Check" and "Other" in the drop
down box.

I need a way to force the user to add the check number if "Check" is
selected. The results would display "Check3456" (without quotes) if the
payment was made by check number 3456. If there were no check number I need
to be able to enter "?" and display the results as "Check?"

Of course if the payment were by cash or other the results would only be
"Cash" or "Other"

If it's possible to do this, how would the code look? I'm using Access
2003


Thanks
Hank

 

[ruralguy via AccessMonster.com]

I'm not sure of everything you want to accomplish but the Form's BeforeUpdate
event is where you would do the verification and make Cancel = True to stop
the update until you are satisfied with the input.

 

[Hank]

Thanks for the reply

What I hope to accomplish is to force the user to record the check number if
a customer pays by check. However the work "Check" plus the check number
should be recorded together so the end results would read "Check1234"
Sometimes a check does not have a number (not very often) - so then the user
needs to be able to enter "?" as the check number.

I'm somwhat green to this - as you can tell.

 

[ruralguy via AccessMonster.com]

What is your reason for not having a separate field for the check number?

Thanks for the reply

What I hope to accomplish is to force the user to record the check number if
a customer pays by check. However the work "Check" plus the check number
should be recorded together so the end results would read "Check1234"
Sometimes a check does not have a number (not very often) - so then the user
needs to be able to enter "?" as the check number.

I'm somwhat green to this - as you can tell.

I'm not sure of everything you want to accomplish but the Form's
BeforeUpdate

[quoted text clipped - 21 lines]

 

[Hank]

The only reason I have is that a deposit report is generated. This report
groups transcations by Cash, Check, and Other. The check number does need
to show on this deposit report, but maybe a seperate field might be the way
to go.
If I did that, is there a way to combine the two seperate fields so the
final results would show "Check1234" - and the grouping would be the same?
Thanks again
Hank

What is your reason for not having a separate field for the check number?

Thanks for the reply

What I hope to accomplish is to force the user to record the check number
if
a customer pays by check. However the work "Check" plus the check number
should be recorded together so the end results would read "Check1234"
Sometimes a check does not have a number (not very often) - so then the
user
needs to be able to enter "?" as the check number.

I'm somwhat green to this - as you can tell.

I'm not sure of everything you want to accomplish but the Form's
BeforeUpdate

[quoted text clipped - 21 lines]

Thanks
Hank

 

[ruralguy via AccessMonster.com]

Of course. It is always easy to put fields together.

The only reason I have is that a deposit report is generated. This report
groups transcations by Cash, Check, and Other. The check number does need
to show on this deposit report, but maybe a seperate field might be the way
to go.
If I did that, is there a way to combine the two seperate fields so the
final results would show "Check1234" - and the grouping would be the same?
Thanks again
Hank

What is your reason for not having a separate field for the check number?

[quoted text clipped - 15 lines]

 

[Hank]

Thanks
Easier work for me.
Hank

Of course. It is always easy to put fields together.

The only reason I have is that a deposit report is generated. This report
groups transcations by Cash, Check, and Other. The check number does need
to show on this deposit report, but maybe a seperate field might be the
way
to go.
If I did that, is there a way to combine the two seperate fields so the
final results would show "Check1234" - and the grouping would be the same?
Thanks again
Hank

What is your reason for not having a separate field for the check
number?

[quoted text clipped - 15 lines]

Thanks
Hank

 

[ruralguy via AccessMonster.com]

That is why I suggested it.

Thanks
Easier work for me.
Hank

Of course. It is always easy to put fields together.

[quoted text clipped - 13 lines]