Checkboxes

[sandrothaver]

Hi

I'm quite new to access. I have 11 checkboxes in my form to select 1 haelth district from 11. How do get this data to reflect cumulatively (in one column as opposed to 11 like it does now) in my queries and tables.

Thanks!

Sandro

 

[Rabbie]

Hi

I'm quite new to access. I have 11 checkboxes in my form to select 1 haelth district from 11. How do get this data to reflect cumulatively (in one column as opposed to 11 like it does now) in my queries and tables.

Thanks!

Sandro

Why not use a combobox to allow the user to select the require Health District?

 

[sandrothaver]

Hey Rabbi

Thanks for the reply The combo-box will work perfectly, except that we want the form to mirror the original data collection form, so it has to be checkboxes.

Thanks
Sandro

 

[Rabbie]

Hey Rabbi

Thanks for the reply The combo-box will work perfectly, except that we want the form to mirror the original data collection form, so it has to be checkboxes.

Thanks
Sandro

I understand. Then you need to have some VBA code behind the form to insert the data from the checkboxes into your record as a single field. The checkboxes would then be unbound fields on the form

 

[sandrothaver]

Got It! But please tell me the quickest and easiest way to get my hands on the code, learn, understand and use it! This will truly set me free, I know.

 

[neileg]

An option group would be better. It will look pretty much like a set of checkboxes but it will allow the user to select only one district. You then populate just one field in your table with the district ID by setting this field as the data source for your option group.

 

[sandrothaver]

Hey Neil

The option group worked like a charm! Thanks! Can you suggest the quickest way that I can learn about VB code?

Thanks again

Sandro

 

[neileg]

Keep visiting these forums. That's how I learned!

 

[sandrothaver]

VB code to make a field null on update

Thanks Neil, that sounds like the best plan. Please can someone send me an example of code to use to make a field null after update?

Sandro

 

[neileg]

Why do you want it to be null? You can delete the content of a text box but you will be left with a zero length string (ie ""). A numeric field will be a zero.

 

[sandrothaver]

Hi Guys
Please can anyone tell me what's wrong with the code below (I want to make the Number Assistive Devices dispensed field null after the update of the cadre field):
Private Sub Cadre_AfterUpdate()
If Cadre.Column(0) = Primary Health Care Nurse Then
Number Assistive Devices dispensed.Locked = True
Number Assistive Devices dispensed.TabStop = False
Number Assistive Devices dispensed.Visible = False
Else
Number Assistive Devices dispensed.Locked = False
Number Assistive Devices dispensed.TabStop = True
Number Assistive Devices dispensed.Visible = True
End If
End Sub

Thanks
Sandro

 

[neileg]

Primary Health Care Nurse should be in quote marks.

 

[sandrothaver]

Thanks Neil, I've got this one working now. How would I add another after update to this event? I would like to make another subsequent field null but on a different entry in the cadre field...do I just go AND...???

 

[neileg]

Insert a new If after your End If.

 

[sandrothaver]

Works Neil. Thanks mate!