Data entry prevention?, tabular vs columnar

[TacoBueno]

Kinda stuck at deciding what I should do here.. What would be the best way to prevent a user from entering data into a tabular form without making sure a certain member exists first?

for example if I have a columnar form

BOXA BOXB (invisible or disabled by default)

1 of 2

I can have it check to see if BOXA has data
if it DOES i can make BOXB available for data entry

but lets say I have a tabular form....

BOXA BOXB
BOXA BOXB

1 of 2

How can I make it so that BOXB will not accept data entry UNLESS its corresponding BOXA has data in it already?...

A:[asldkfjaskd] B:[AVAILABLE FOR EDIT]
A:[] B:[NOT AVAILABLE UNTIL MEMBER IS CREATED]

It needs to be in tabular form too.. sigh.. anyway.. thanks for any help you might be able to provide

 

[RuralGuy]

It seems to me Conditional Formatting should work for you if you have Access 2000+.

 

[TacoBueno]

It seems to me Conditional Formatting should work for you if you have Access 2000+.

Ok, that seemed to work for text boxes.. got any suggestions on how to do it for check boxes as well?.... thanks

 

[RuralGuy]

Unfortunately, MS decided not to offer that particular feature for CheckBoxes. Sorry but I have no work around suggestions either.