gusbrunston
Programmer
Had some help on this in the past, but can't find it now...
A table (Properties) has many check boxes to indicate what "amenities" belong with a particular property (record).
I'd like to construct a string, e.g., "AC BA FD FP FY WP", which means, "Air conditioned, balcony, Formal diningroom, Fireplace, Fenced yard, Water paid", from the checks boxes the user clicks in the entry form. Something like this (in basic Basic):
I hope what I'm trying to do is clear. I can probably figure out how to do this in VB, but your help would be nice. Is this the best way to do this in Access2000? Should I use a query? Your suggestions would be most appreciated, muchas gracias, merci, etcetera, etc...
X-)
Gus Brunston
An old PICKer
padregus@home.com
A table (Properties) has many check boxes to indicate what "amenities" belong with a particular property (record).
I'd like to construct a string, e.g., "AC BA FD FP FY WP", which means, "Air conditioned, balcony, Formal diningroom, Fireplace, Fenced yard, Water paid", from the checks boxes the user clicks in the entry form. Something like this (in basic Basic):
Code:
If ckboxAC = True then AStr = "AC "
If ckboxBA = True then AStr = AmenStr + "BA "
If ckboxFD = True then AStr = AmenStr + "FD "
If ckboxFP = True then AStr = AmenStr + "FP "
If ckboxFY = True then AStr = AmenStr + "FY "
If ckboxWP = True then AStr = AmenStr + "WP "
If etcetera, etc....X-)
Gus Brunston
An old PICKer
padregus@home.com
