Feild visible or not visible based off of combo box

[cbende2]

It was simply my choice to use two forms, I like the flow better.



I don't really understand what you want me to do... do you mind going in the sample database i sent and making the changes in there and then post it back on here so i can see the changes in the actual database?

[June7]

I did some more edits in my previous post.

Exactly what do you not understand about the instructions?

[cbende2]

Do i get rid of my code that i used if i change to yours? like this is what i have now...

Database4 - Copy.zip

[June7]

If you add field to table and modify combobox then the code can be replaced.

[cbende2]

Yeah its not working right for me.

[June7]

Posted db does not show attempt to implement my suggestions. The suggested changes are simple and I think clearly explained.

What does 'not working right' mean - error message, wrong results, nothing happens.

[cbende2]

I'm getting a parameter error and then an object error:



Database4 - Copy.zip

[June7]

The popup is probably because Access can't find something that is referenced in query so it prompts for input.

Me is used in VBA code behind form or report. It is an alias reference to that same form or report.

Describe exactly the edits you did and post your attempted code or provide the db.

The suggested edits are:

1. add and populate field named PlanField to Staff table

2. modify combobox RowSource and place combobox in form header

3. change VBA code

[cbende2]

I did all three, but what am i populating the field "PlanField" with? what exactly is going in that field?

[June7]

The name of the field from PlanTable that the user is assigned.

[cbende2]

Ok, I've done that, but it is still not checking off the correct box in the plan table.

Database4 - Copy1.zip

[June7]

Need one checkbox named chkMM.

Need to select [Event Procedure] in the combobox AfterUpdate event property.

[cbende2]

[Next].....

[cbende2]

Ok, So am I making the chkMM field in StaffTable or PlanTable? and also, I'm still getting an error with the event procedure, my code is :

Option Compare Database
Private Sub cboName_AfterUpdate()
Me.chkMM.ControlSource = Me.cboName.Column(2)
End Sub

[June7]

No, I did NOT say to create a field named chkMM. I said create a single UNBOUND checkbox control on form that is named chkMM.

The only field I said need to add is PlanField in StaffTable.