Search results

Thanks linq. However, when I use the code in both AfterUpdate and FormCurrent, it doesn't work right. First off, the IndustryClassification listbox is visible when the form is opened. When I try to select an item in the TypeOfBusiness list box, the IndustryClassification list disappears and...

Okay then, after much trouble and confusion, I finally realized I need to use an Extended listbox in order to allow for multiple items to be selected from a list on my form (rather than the evil multiple selection combobox!). However, now I am trying to figure out how to make one listbox...

Won't let me edit my post to add the link to the other thread, so here it is.

Stemming off the issue I started with here... Basically, I need a better way to create a drop-down on my form that allows the user to select multiple items in the drop-down. I was advised not to use a combobox bound to a Multi-Value Field on my table. What is a better way to do this? It seems...

Oh wow, thanks for that info! I didn't realize how troublesome they could be. Would it be a better option to have a field in the table for each of my current combobox options, and then add them to the form as a checkbox??

Wow... it's too early for me this morning. Just made the connection in my head that the yellow is the debugger. It didn't give me any error message, though, just brought up the debugger with that line highlighted. I have no clue where to go from here. Any suggestions??

The items listed in the combobox are multiple selection, meaning they are selected with check boxes. So, would the checkbox be considered the first column (0) and the actual word "Industry" considered the second column (1)? Or are they considered the same column (0)? Either way, I tried changing...

Gotchya. Thanks for pointing that out. Here is what I used: Private Sub Form_Current() Dim varItem As Variant Dim found As Boolean If Me.TypeOfBusiness.ItemsSelected.Count Then For Each varItem In Me.TypeOfBusiness.ItemsSelected If Me.TypeOfBusiness.Column(0...

P.S. isn't that last bit of code you posted the same as what you posted originally? I don't see a difference.

Hmm. It wouldn't allow me to make a breakpoint by the dim lines. Not even sure what that means or what the purpose of that is. Always more to learn about Access... I tried that and it didn't help! I am making an assumption that you intended for the code to be put in the AfterUpdate of the...

Correct, it is a multi-select combobox. Thanks for the suggestion! However, the code didn't work. It simply made the IndustryClassification invisible and didn't appear when any box was selected.

Hi all, I have a combobox on my form called TypeOfBusiness, with fields including Corporation, Education, Industry, Non-Profit. In order to make a second combobox called IndustryClassification appear when Industry is selected from the TypeOfBusiness combobox, I have used the following code...

Hi all, I am trying to accomplish the same thing as the OP. I have tried using this code and following the suggestions of the other posters but can't get it to work right. Here is the code I used: Private Sub Form_Current() If Me.TypeOfBusiness = "Industry" Then...

... and when I close my database altogether and re-open it, none of the subform records show!

I shouldn't have spoken so quickly :p It seems my problem progresses... When I open up my form to enter students into the subform, I get the error "Field Cannot Be Updated" or somewhere along those lines. If I press enter I can still enter the record and save it. But, I do want to know why that...

Oh, perfect! Thank you, you are my hero! It got to the point where I was thinking about it way too much and my brain was totally clouded. I ignored that project for a day and it all makes sense now, hah. Thanks again!

Here it is. I copied my database and deleted all the student information... but now I can't even click into the subform to enter data. Really confused as to how that happened since all I did was copy and delete data. MUCH thanks for your help!

I double checked it all again... all names and record sources are correct... I still get the same error. I'm about ready to tear my hair out and start over!

I double-checked all the spelling, there are no errors in the spelling. What else would be causing that error?

Still not working :confused: When I put in that code it gives me the following error: "The record source 'FROM tbl_StudentInfo INNER JOIN..." specified on this form or report does not exist. The name of the recordsource may be misspelled, the recordsource was deleted or renamed, or the record...