Entering a default

G

Gary Nelson

In Access2000, I have a form with a view that I am being asked to change.
Currently, the user enters a PrintColor, "Laser Black". It has been
requested that once Laser Black is selected, that the "PaperType" default to
"80# Uncoated Paperback". I am uncertain how to do this in a view. I have
attached below the view. Can you please help me to accomplish this task?
Thanks in advance.
Column Alias Table Output
Criteria Or.... Or....
JobNum BookAll 1
PrintColor BookAll 1
PaperType BookAll 1
CvrPrinterID BookAll 1
CvrMediaID BookAll 1
CvrStockID BookAll 1
PBCvrStockColorID BookAll 1
CBCvrStockColorID BookAll 1
CvrPaperID BookAll 1
CvrRemarks BookAll 1
CvrColorID BookAll 1
CvrHalftones BookAll 1
TwoSidedCvr BookAll 1
Side1Color1 BookAll 1
Side1Color2 BookAll 1
Side1Color3 BookAll 1
Side1Color4 BookAll 1
Side1Color5 BookAll 1
Side1Color6 BookAll 1
Side2Color2 BookAll 1
Side2Color3 BookAll 1
Side2Color4 BookAll 1
Side2Color1 BookAll 1
Side2Color5 BookAll 1
Side2Color6 BookAll 1
LamMatID BookAll 1
Varnish BookAll 1
DieStatusID BookAll 1
IBTtoCreate BookAll 1
SuppliedDies BookAll 1
ExistingDies BookAll 1
MechMaterialID BookAll 1
StampingNotes BookAll 1
ClothType BookAll 1
StampHitID BookAll 1
ExtraCovers BookAll 1
CvrOverage BookAll 1
JacketingDesc BookAll 1
IBTToPrntJacket BookAll 1
JacketColors BookAll 1
JacketMaterial BookAll 1
JktPrtMethod BookAll 1
JacketMedia BookAll 1
JktPprSize BookAll 1
JktProof BookAll 1
JktLam BookAll 1
JktPrfType BookAll 1
JktCol1 BookAll 1
JktCol2 BookAll 1
JktCol3 BookAll 1
JktCol4 BookAll 1
CvrProof BookAll 1
CvrProofFax BookAll 1
CvrProofTypeID BookAll 1
AllCovers BookAll 1
CovMedProcID BookAll 1
C1 BookAll 1
M1 BookAll 1
Y1 BookAll 1
K1 BookAll 1
C2 BookAll 1
M2 BookAll 1
Y2 BookAll 1
K2 BookAll 1
C3 BookAll 1
M3 BookAll 1
Y3 BookAll 1
K3 BookAll 1
C4 BookAll 1
M4 BookAll 1
Y4 BookAll 1
K4 BookAll 1
BindStyleID BookAll 1
TxtOver BookAll 1
OriginCode + PrintCode + '-' + CONVERT (varchar, JobNum) FullJobNum 1
FandGTypeID BookAll 1
DateIn BookAll 1
TotalWidth BookAll 1
ClothGrade BookAll 1
PublisherID BookAll 1
StampedCaseforApproval BookAll 1
PMSCustomer BookAll 1
SuppCvrsDue BookAll 1
0
 
Top