field dependent on another field

Can you create a field in a table that can only be filled out if another
field is filled out? For instance, you need to know how much somebody paid,
but only if they have already paid. Otherwise, how much they paid should be
left blank. Is there a way to do that?

Generally the logic is that if an amount of payment is entered a payment has
been made. There is no need for a field to indicate a payment has been made.

Steve



"felicitator72" wrote in message
...
Can you create a field in a table that can only be filled out if another
field is filled out? For instance, you need to know how much somebody
paid,
but only if they have already paid. Otherwise, how much they paid should
be
left blank. Is there a way to do that?

"How" depends on "what", as in "what is your data structure?" ...

Are you recording one record per payment? Or are you using a single field
to show total paid so far (and updating it as new amounts are paid)?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"felicitator72" wrote in message
...
Can you create a field in a table that can only be filled out if another
field is filled out? For instance, you need to know how much somebody
paid,
but only if they have already paid. Otherwise, how much they paid should
be
left blank. Is there a way to do that?