BOL Selection Req'd

A

aMack

We have a process to create BOL's.

I need to enter code so that the users cannot complete a BOL without
selecting one of three Checkboxes.

[Prepaid], [Collect] or [3rd Party]


I tried a test:

if isnull(me.prepaid) then
msgbox "Must Select PPD, Collect or 3rd Party"
cancel = true
me.Prepaid.setfocus
End if

Did not work. Maybe because [Prepaid] is a Y/N field??

Assistance please
 
R

ruralguy via AccessMonster.com

How are you getting 3 choices out of a Yes/No field?
We have a process to create BOL's.

I need to enter code so that the users cannot complete a BOL without
selecting one of three Checkboxes.

[Prepaid], [Collect] or [3rd Party]

I tried a test:

if isnull(me.prepaid) then
msgbox "Must Select PPD, Collect or 3rd Party"
cancel = true
me.Prepaid.setfocus
End if

Did not work. Maybe because [Prepaid] is a Y/N field??

Assistance please
Click to expand...
 
R

ruralguy via AccessMonster.com

I would think that Prepaid and Collect were mutually exclusive and could be
handled by one field but 3rd party could apply to either. Am I correct there?
Sorry for digging into your business process.

Are you still in the design stage enough to alter the table or should I
assume we need to proceed with the table as it is? If so then we will need
to check each field for a Null before we assume they have no completed the
BillOfLading, correct?

With a predefined coding system, you could handle it with one integer field
that defaults to zero.
there are three different data fields each are y/n checkboxes
We have a process to create BOL's.
Click to expand...
[quoted text clipped - 14 lines]
Assistance please
Click to expand...
Click to expand...
 
A

aMack

This process has been inplace for over a year at numerous locations.

You did give me an idea to place a value on the selections made and right
code to look at that single field.

Pretty sure ti will work.
 
R

ruralguy via AccessMonster.com

With one field defaulting to an invalid code such as zero then it would be
easy to check an see if it had been completed yet. Post back if you still
need assistance. Otherwise, have fun! :)
This process has been inplace for over a year at numerous locations.

You did give me an idea to place a value on the selections made and right
code to look at that single field.

Pretty sure ti will work.
We have a process to create BOL's.
Click to expand...
[quoted text clipped - 14 lines]
Assistance please
Click to expand...
Click to expand...
 
D

Dirk Goldgar

aMack said:
We have a process to create BOL's.

I need to enter code so that the users cannot complete a BOL without
selecting one of three Checkboxes.

[Prepaid], [Collect] or [3rd Party]


I tried a test:

if isnull(me.prepaid) then
msgbox "Must Select PPD, Collect or 3rd Party"
cancel = true
me.Prepaid.setfocus
End if

Did not work. Maybe because [Prepaid] is a Y/N field??

Assistance please
Click to expand...

If Prepaid is a yes/no (boolean) field, then it can't be stored in the
table as Null. It's either True or it's False. It's true that it's
possible to have a Null boolean field as the result of an outer join in
a query, but I'm guessing that's not the situation here.
 
Top