Question Help with form controls

[josephbupe]

Please, I need your help.

I have a form with a few controls in it. One of the controls is a combo box (cboInvestigator) where

the database administrator(s) can select the investigator;hence, assigning the current case to

him/her. Initially, the case would have been assigned by default to the administrator(s).

What I want is to ensure that when the administrator(s) selects a name of the investigator from the

combo box other than the administrator(s) name, the administrator should be prompted to tick one of

the two check boxes.

The available administrators are:-

admin with AccessLevel=1
joseph with AccessLevel=1

The rest are users/investigators with different AccessLevels.

The two check boxes are:

chkAssigned
chkClosed

I will appreciate your help.

 

[jonathanchye]

hmm, not very sure of your question but I hope I can help.

In your case you should have one table called tblInvestigators. This table should contain a field called "Name", "AccessLevel", "chkClosed" and "chkAssigned".

Your form then should be based on this table. Cboinvestigators control source should be "Name". For the prompt you might want to add something lto cboInvestigator's AfterUpdate event. There are various ways to do this depending on what you want to achieve.

Using the control wizard in Access2010, I would just create a combobox and then make it to find a record based on the selection. This should filter the records according to the selected. You can then include two checkboxes with the appropriate control source.

On each of the checkbox's AfterUpdate event have something like this :

For chkClosed :

If Me.chkClosed = True Then Me.chkAssigned = False

And the opposite for chkAssigned so you can't have 2 True values.

 

[josephbupe]

hmm, not very sure of your question but I hope I can help.

In your case you should have one table called tblInvestigators. This table should contain a field called "Name", "AccessLevel", "chkClosed" and "chkAssigned".

Your form then should be based on this table. Cboinvestigators control source should be "Name". For the prompt you might want to add something lto cboInvestigator's AfterUpdate event. There are various ways to do this depending on what you want to achieve.

Using the control wizard in Access2010, I would just create a combobox and then make it to find a record based on the selection. This should filter the records according to the selected. You can then include two checkboxes with the appropriate control source.

On each of the checkbox's AfterUpdate event have something like this :

For chkClosed :

If Me.chkClosed = True Then Me.chkAssigned = False

And the opposite for chkAssigned so you can't have 2 True values.

Hi Jonathan,

I appreciate your help and especially on handling the chk controls.

As for the investigators, you may wish to know that actually there is a table called "tblUsers" and both the users and administrators are stored in this same table.

Essentially, what i want is a way to distinguish whose name is in the combo box of the current record; is it the user with access level 1 (administrator)? or the user with access level 2 and above (investigator)? If selecting the user with access level 2 and above then the combo box will prompt for the chk box to be checked.

Regards.

Josephbupe

 

[jonathanchye]

Can you please post the tables involved and their relationships?

 

[josephbupe]

Hi Jonathan,

I have attached a striped copy of my project. The form with the controls I mentioned is "F_Daily_Incidents_add."

I appreciate.

josephbupe