Search results

Thanks, that helps...this was only the start of what I was doing, just had to get the form down before all the other language was input. Will check out your So now I have all the language, and it appears to be working correctly. I didn't know if there was a way to compress only the visible...

Hopefully this goes through...

Two places: Private Sub Form_Current() and Private Sub Combo174_AfterUpdate() Combo174 is the combo-box that has the department

Okay, so I thought it was going to work...it still isnt updating for each new record...here is what I have, there is still work to do, but this is the start: Select Case Me.Combo174.Column(1) Case "Collections": Me.Additional_Charge_Input.Visible = False...

Disregard that, I put the quota marks on the other side of the colon...let me try it now

That works, thanks. I tried the Select/Case method, and here is the language: Private Sub Form_Current() Select Case Me.Combo13.Column(1) Case "Collections": Me.Refunds_Input.Visible = True Me.Appeals_Input.Visible = False Case "Posting:" Me.Refunds_Input.Visible...

That's it, thanks Paul. One more thing and I should be set, for now...if my Combo Box has two values, the first which they are selecting, and the second which shows in the drop-down, but not when it is selected, how do I look up the hidden value from the combo box to use with the conditional...

Thanks...what if you wanted the visibility, or lack of, to depend on the selection, so if it was Collections, you would have: If Me.Combo13 = "Collections" Then Me.Refunds_Input.Visible = True Else Me.Appeals_Input.Visible = False But if it was Posting, you would have: If Me.Combo13 =...

Ok, thanks...it is working, but when I scroll through the records in form view, that field doesn't show up in any of the fields. I saw in another post that the same language would need to be written into the current field? Can you confirm?, or, how would I make it so where I click on a new...

Thanks! Ok, so here are the fields: Employee Name Date of Production Appeals Input Refunds Input Depending on the Department Name, which is linked to Employee Name in Relationships, I would want one to show up. So, if it is "Collections", I would want "Appeals Input" to show up and not...

I am in the design view of this form...I would go to the Property Sheet of the Combo Box, and then input the Conditional Visibility language in the coding?

Thanks for the help...I need to tell you that I am a novice at Access...are you going to tell me to get professional help, or is this something that can be done by a novice...

I am putting together what appears to be a simple database for our "Production" department to use. There are 4 different types of employees in this department, or 4 different job types. I would like to create form that would show their job responsibilities only when they select their job...