populate a field

S

Sheri

Hello. I am using Office XP. I have a database tracking
receipts of money. I have two fields for credit card
entry. Field names: Payment and CardNumber. Payment
entries are for credit cards or cash. I'm using a form.

What I would like to do is:

If the Payment field contains a credit card entry (VISA,
MC, etc) go directly to the CardNumber field. If the entry
in the Payment field says "Cash" the CardNumber field is
skipped.

I know I've done something like this before but am brain
dead today. I appreciate any/all help offers !

THANKS and happy days !
 
E

Eric Cardenas

| Hello. I am using Office XP. I have a database tracking
| receipts of money. I have two fields for credit card
| entry. Field names: Payment and CardNumber. Payment
| entries are for credit cards or cash. I'm using a form.
|
| What I would like to do is:
|
| If the Payment field contains a credit card entry (VISA,
| MC, etc) go directly to the CardNumber field. If the entry
| in the Payment field says "Cash" the CardNumber field is
| skipped.
|
| I know I've done something like this before but am brain
| dead today. I appreciate any/all help offers !
|
| THANKS and happy days !
------------
Hi Sherri,

You can change the Enabled property of the Card number textbox depending on
the value of the Payment textbox. You set Enabled=False when value other
than "cash" is entered and Enabled=True when value of "cash" is entered.
You change this property in the AfterUpdate event of your Payment textbox.

Hope this helps,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top