Search results

Perfect! Thank you so much for your help the past few days!

When typing that code in, I keep getting a compile error reading a syntax error or expecting: =

Okay I'm sorry for not understanding this at all, but I did [Event Procedure] like I said, and then when I open VBA, I have the code already there from the dropdown boxes Private Sub combo125_afterupdate() If Combo125 = "CA" Then [Combo39].Visible = True [Combo41].Visible = True...

I'm not entirely sure if this is what you meant or not but for the form property sheet, I went to "On Current" and selected [Event Procedure] from the dropdown box.

sorry but what do you mean by "call"? DoI put that code in the line "For Current" or do I have to enter it into code?

yeah it's currently on that setting. I'm not sure why it will not show up until I manually select CA from the dropdown box. In addition to not showing up until I manually type it in, if I go to a different record that is not CA after typing CA into the previous record (i.e. the boxes show up)...

I'm essentially importing data so that the state dropdown box is automatically filled. However, for example, if CA is automatically selected, the corresponding additional drop down boxes do not show up. To get them to show up, I had to delete the automatically dropped down CA value, and then...

Well almost like a charm. I can get them to appear/disappear when I'm typing the data in manually. However, I am going to be using this form as a template and when I imported the data, the boxes did not automatically appear, even with CA,GA, MA selected. Any suggestions?

It worked like a charm. Thank you so much!

Oh, wow. Okay that's helpful for sure. I only have states being pulled from combo 125 and then additional information is dependant on what is being pulled from that combo box. However, I'm still getting an error message and was wondering if you could detect it. The expression After Update...

Okay I came up with an error: Compile error sub or function not defined. The following are my first 2 sections of my code and I just continued that for all 11 drop down boxes. Side note: thank you so much so far. You must be a very patient person haha Private Sub Combo125_AfterUpdate() If...

well I want the visibility of Combo83 to depend on the answer provided in Combo125. Is it still the same code?

Private Sub Combo83_BeforeUpdate(Cancel As Integer) If Combo125 = "CA" Then Dropdown [Combo83].Visible = True Else Dropdown [Combo83].Visible = False End If End Sub This is what I put it and it still did not change anything. I put 125 instead of 83 because that is the box that determines if 83...

Private Sub Combo83_AfterUpdate() If Value = "CA" Then Dropdown.Visible = True Else Dropdown.Visible = False End If End Sub This is just for one of the dropdown boxes but I've been using this same one for all of the additional dropdown boxes but just changing the "if value"

Makes sense. I have a bunch of data so I'm probably just going to make a new column for comments. Thank you for your help!

Oh okay I follow that. Is it possible to leave a comment on a record of the form that will stay forever but only on that record? In plain English, it is for management to make any comments about the data presented on the form.

I have an unbound text box. I have about 20 fields per record (one page essentially on the form) but they aren't really that relevant to what I want to do. I was just hoping to have an area on the form that could be used to insert comments by a user. I want to save my database as a template so...

Hey thanks for replying! I have a text box that I want to have text in obviously but I want it to only appear for a single record (not in a field or anything, but for the single record in a form of over 1000 records). However, I do want a text box for every record. Hope this helps

Hey everyone, I ran into something that I haven't been able to figure out. I have a text box in a form (unbound) and when I go to add text into it, the text carries over from one record to another but I want it to be exclusively for that record. Any help would be greatly appreciated! Thanks!

I have a new one for you: I wanted to change the visibility to off because I don't want the additional information to show unless the state is selected but using the code you gave me earlier along with the visibility off, the drop down box remains invisible and I was wondering if you could give...