Search results

Follow up question. I have now put the form into a navigation form and I can't get it to work. I have a similar subform from which the user also selects a name to populate the information in that subform, which again works until put into the navigation form. I know you have to change the code...

Nevermind, figured it out. It was under the event procedure. Thanks again!

Thanks michaeljryan78! Can you explain what it was that you actually changed to get it to work? I compared the property sheets of the one you fixed and the original and can't find any difference between the two.

OK, so I may have been wrong. When you open the file it says Access 2007 at the top of the screen, but just opening Access from the windows start button it says Access 2010. So I guess I do have 2010? Sorry about that.

The file's too big to upload without compressing. I don't know why this isn't working, I've uploaded this filed before, and I'm using 2007.

It's 2007 so it should work. I tried compressing it again. Hopefully that will fix the issue.

Ask and receive. The form is BasicTestOneF.

The form also works just fine by itself, its when I put it as a subform on another form that it doesn't work.

The After Update is just: Me.Requery And the SQL is just: SELECT ICInfoT.ICBusName FROM ICInfoT; I double checked and the names are correct. It's a very simple form because, again, I'm just wanting to learn how to do this and maybe use that knowledge later on. Thanks for your help!

I am trying to do a test of something, mostly just to learn how to do it, that I feel should be incredibly simple, but I cannot for the life of me get to work. All I am trying to do is get a subform to requery after choosing a name from a combobox on the subform itself, thus updating the...

pbaldy: Thanks, I got it to work! Pat Hartman: If you can think of a better way to do what I'm trying to do that would be fantastic, though what I have now does work for what I need. The reason I have to search multiple tables at once is because each business name can have any number of...

Thanks for the quick reply. Could you elaborate how to get the combobox to work with the SQL? Would the 'WHERE' clause need to be set up/linked to the business name in some way, since it will change based on what the user selects? I understand the SELECT, FROM, AND UNION clauses (the easy part...

I'm not sure if this is the right place for this, so if it's not I apologize in advance. I'm a beginner in Access and building a database for work, and I came across union queries through my extensive Google searches, and it is something that would work perfectly in my DB...except for one key...

I would prefer to stay away from having to put a subform on the form due to space restrictions, but I like the idea of having a combobox update a listbox to show all the states. How do you set it up so that the row source in the list box is what is selected in the combobox? I looked around the...

Attached is my database. Under the form "ICinfoF" the "State" field is the one I'm talking about. There are no events on the properies sheet that I can find. Thank you so much for your help with this!

I may not have explained what I have very well. What I have is a combo box that when you hit the drop down arrow a list of 50 checkboxes shows up. After selecting the appropriate states and hitting enter it then displays in the format: Alabama, Colorado, Nevada. What I would like is for it to...

I have a check box list on my form for all 50 states, so the user can choose any number and any combination of possible states, which I need the user to be able to do, but when it displays the data it does so horzontally and delineated by a comma. The problem with this is that if enough states...

Thanks to you both, I got it to work!

I feel like this should be a simple problem, but I'm still new to VBA and am having trouble figuring it out. I have a form that has a text box giving some information, but I only want the text box to show if the account name is a specific name. So if the account name is "Longhaul" then the...

I shouldn't be surprised. But thanks for the idea though, I'll try that out.