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

 

[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.

 

[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 (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com

 

[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