Check Box and Combo Box Blank

[ErikRP]

I have a form that has 3 check boxes and each check box has a corresponding combo box. For each check box, I want a user to check if the situation applies and if so, they then go to the corresponding combo box and select a value from the list. For example, say I have 3 crime categories - homicide, theft and automobile. If the crime committed was a theft, they'd check the Theft box and then go to the Theft combo box and select what type of theft it was. The way I have it set up now is that the combo box only appears if the box is checked, and disappears if the box is not checked.

The problem that I'm having is when, for example, the Theft check box is checked and a value is picked in the the Theft combo box. If they then realize they actually want the Automobile check box instead they uncheck the Theft check box but the value in the Theft combo box still shows up on the table. I need to reset each combo box if the corresponding check box is blank.

A last little twist in my situation is that I want the user to be able to pick more than one check box (and its corresponding combo box).

Any help is MUCH appreciatated!!!

 

[PhilE]

This is the old problem of bound data being updated and there is little control over it. Going unbound would be the best solution but it's a lot of effort, so instead you could try doing this on the clickevent of the tick box..

OnClickTickA

If me!TickA then
Me!ComboBoxA.enabled=true
else
Me!ComboBoxA = Me!ComboBoxA.oldvalue
Me!ComboBoxA.enabled=False
end if

Good luck

 

[ErikRP]

Great - thanks PhilE - it seems to be working perfectly! Much obliged!

 

[helenliu]

Hello,
I have created an "Archive" check box where i wish "BoxNumber" textbox and "RecallNumber" textbox on the same form to be greyed out if the "Archive" check box is not checked/ticked. How do i accomplish this? I am a beginner at Access so please use simple language. Many thanks!
Helen

 

[pbaldy]

Look at conditional formatting (Format/Conditional Formatting).

 

[helenliu]

bingo!

That worked brilliantly. Thank you for pointing me in the right direction!!

 

[pbaldy]

No problem; glad you got it sorted out.

 

[helenliu]

Set a maximum number of records per table

Hi,

I'd like to limit the number of records my "Keywords" field can contain to a maximum of 10 ie, i'd like to restrict the number of entries (rows) users can input into the "Keywords" table to max of 10.

Once again, I am a beginner at Access so if i can accomplish this simply that was be great.

Thank you,

Helen

 

[pbaldy]

I suppose the easiest way would be to use the before insert event of the form used to add records. In that event, use a DCount to test the number of records in the table, and if the next one would be too many add set Cancel = True to stop the insert (I'd add a message to the user as well).

 

[tbarkdull]

Combo Box not populated from Table

I have a user with an Access 2000 database he himself created. Now that someone else has accessed it, most, but not all combo boxes do not show any information. All are pulling data from tables. Opening each table reveals the appropriate data. But, as I said, most are blank. Is there a global issue I can look for or what am I missing?