FOR PURPOSES OF THIS DISCUSSION; I'LL SIMPLIFY
I HAVE A SUBFORM - A CONTINUOUS FORM WHERE UP TO 8 ROWS OF
DATA CAN BE DISPLAYED. EACH ROW CONTAINS A DATE_COMBO_BOX.
CURRENTLY, WHEN i KEY A DATE INTO THAT BOX (LIMITTOLIST = NO) THE DATE SHOWS IN THE COMBOX BOX FOR _->EACH<- ROW. I WOULD LIKE TO ALLOW THE USER TO KEY IN AN ADDITIONAL DATE FOR JUST ONE ROW. OF COURSE THIS SUBFORMS RECORDSOURCE IS A
QUERY AND THE DATE_COMBO_BOX ON EACH ROW HAS IT'S OWN QUERY
HOW DO I PREVENT THE UPDATING FROM OCCURRING ON EACH ROW'S DATE_COMBO_BOX OF THE SUBFORM.
IS THIS EVEN POSSIBLE ?
A RELATED QUESTION IS IT APPEARS THAT WE HAVE EVENT ACCESS TO ONE ROW AT A TIME BUT OBVIOUSLY THESE CONTROLS ARE IN SOME ARRAY SOMEWHERE ???
AND IT WOULD BE GREAT IF I COULD STEP THRU THE ROWS ON THE SUBFORM FOR VARIOUS REASONS. IS THERE SUCH A THING AS DATE_COMBO_BOX(1), DATE_COMBO_BOX(2) ETC...?
THANKS FOR ANYBODY'S TIME..I'M STILL REAL GREEN HERE !
Bob Schmid
bob_schmid@hmis.org
330-746-1010 ext. 1347
I HAVE A SUBFORM - A CONTINUOUS FORM WHERE UP TO 8 ROWS OF
DATA CAN BE DISPLAYED. EACH ROW CONTAINS A DATE_COMBO_BOX.
CURRENTLY, WHEN i KEY A DATE INTO THAT BOX (LIMITTOLIST = NO) THE DATE SHOWS IN THE COMBOX BOX FOR _->EACH<- ROW. I WOULD LIKE TO ALLOW THE USER TO KEY IN AN ADDITIONAL DATE FOR JUST ONE ROW. OF COURSE THIS SUBFORMS RECORDSOURCE IS A
QUERY AND THE DATE_COMBO_BOX ON EACH ROW HAS IT'S OWN QUERY
HOW DO I PREVENT THE UPDATING FROM OCCURRING ON EACH ROW'S DATE_COMBO_BOX OF THE SUBFORM.
IS THIS EVEN POSSIBLE ?
A RELATED QUESTION IS IT APPEARS THAT WE HAVE EVENT ACCESS TO ONE ROW AT A TIME BUT OBVIOUSLY THESE CONTROLS ARE IN SOME ARRAY SOMEWHERE ???
AND IT WOULD BE GREAT IF I COULD STEP THRU THE ROWS ON THE SUBFORM FOR VARIOUS REASONS. IS THERE SUCH A THING AS DATE_COMBO_BOX(1), DATE_COMBO_BOX(2) ETC...?
THANKS FOR ANYBODY'S TIME..I'M STILL REAL GREEN HERE !
Bob Schmid
bob_schmid@hmis.org
330-746-1010 ext. 1347
