Recent content by jonmitch

Actually it did work!!!!!!!!!!! Thanks so much essnrv for all your expert help over the last two days!!!! I greatlt appreciate it!

Thanks essnrv, but here's how I fixed the problem, in case others are wondering. I created a Macro that closed the Switchboard. I put that Macro in the Submit button so that when you type in data to search, it opens the main form filtered and also closes the Switchboard. So when I go back to...

Thanks for the reply back, but that did not do it, plus I am still having the problem that the filter will not go away when I go back to the switchboard. Any more ideas? I'll try anything!

One additional item I was looking to do: The search is set up right now so that it looks for a string of letter in the whole company name. Can it be set up so that it starts at the beginning of the company name? For example, if I type in the letters “ce” in the search, the company Advanced...

I have a switchboard that links to a "Master Form". From the swichboard you can open the form in Add Mode and open the form in Edit Mode. I also have a textbox with a command button next to it that acts as a search for CompanyName to the Master Form. Here's my dilemma: When I type...

I would like so that when you type in a company name in the textbox on the "Switchboard" and then Click the Command Button...it will bring up the record in "Master Form" (a form that I already created). Here is the code that I have in the On Click event of the command button...

Ok, we are making progress...I moved the code to form_open event and do not get the error message anymore, however now when I type in text and hit the command button it does nothing. Do I need to add in some code to go to the master form from the where I am (which is the switchboard)? It seems...

That fix did get rid of the error message so thank you, but now it has caused a new error message: RunTime Error '2465' Microsoft Access cannot find the field 'ItemText' referred to in your expression. When I hit debug, I am brought to this section of code: Private Sub Form_Current() ' Update...

I have looked through other threads here and have come further along in my search function dilemma, but need someone to look at this code: I have created an unbound textbox on my switchboard called txtFind and created a command button called cmdFind. In the On Click Event, here is my code...

I have looked through other threads here and have come further along in my searcg function dilemma, but need someone to look at this code: I have created an unbound textbox on my switchboard called txtFind and created a command button called cmdFind. In the On Click Event, here is my code...

I do have 2 forms. The first is a switchboard that runs many commands, like opening reports and going to the master form, etc... The second is the master form that holds a lot of different information about each company. So, what I want to do is put a Search function on the Switchboard for...

Does anyone know how to include a seach function on a form that will bring you to the record that the person inputted? I have a Switchboard with a lot of functions and one more thing that I want to include is a Search function so that the user can type in the company name and it will bring them...

I have a Group in a Report that I DO NOT want to be sorting by Ascending or Descending. Rather, I would like it to be sorted by values that were put into that field on the form in the specific order that I designate. Let me step back. I created a combo box on the form to be a value list in a...

I have a form with a Combo Box that is a Value List of 7 options that I have designated in a certain order and saves in the main table as "DealStatus". Then I ran a query and took out two of the options under the criteria section. NOw, when I created a report off that Query and have...

Thanks for the Reply Paul. The code above worked perfectly, except for one problem, the Can Shrink/Can Grow did not work. So, the check boxes are not visible, and the correct label shows when check as yes, but the spacing is all over the place. Any suggestions with that? Thanks