Access 2007 Combo Box Help

JayJ24 · 10-10-2009, 07:05 PM

I have a database that has a few tables. One of the tables is Named Software.

Which I created a FORM for that table with the following fields

Fields Name

Software Software_Box
Server
Vendor_Name
Software_Purpose

What I am doing is creating a Combo Box as a search Box. In the wizard I selected "Find a record on my form based on the values i selected in my combo box"

Then I selected the Software table and the Software Field.

I then Named the COMBO BOX 'Software_To_Find'

I then went to the on current and added this code using Code Builder

-Software_To_Find = Software_box 'Update the combo box-

Ok my problem is for some reason when im searching for records soon or later it starts changing the name of the Software to Numbers. I have no clue why it is doing this and I am pretty frustrated now as I been researching and reading for 2 days but can not find another rookie that has gone through this issue before.

Basically when im searching it starts off good all the records are synchronized with the Software Field on the form but then all of a sudden you will start seeing that the names will randomly start getting changed to Numbers.

Can someone please help me?

Thanks

JayJ24 · 10-11-2009, 07:06 AM

Well im thinking i find my problem but not to sure

I had the control source set for the search box and then the same control source set for the software_box

Could that have been my issue?

10-10-2009, 07:05 PM	#1 (permalink)
JayJ24 Registered User Join Date: Jan 2008 Posts: 49 OS: Windows 7	Access 2007 Combo Box Help I have a database that has a few tables. One of the tables is Named Software. Which I created a FORM for that table with the following fields Fields Name Software Software_Box Server Vendor_Name Software_Purpose What I am doing is creating a Combo Box as a search Box. In the wizard I selected "Find a record on my form based on the values i selected in my combo box" Then I selected the Software table and the Software Field. I then Named the COMBO BOX 'Software_To_Find' I then went to the on current and added this code using Code Builder -Software_To_Find = Software_box 'Update the combo box- Ok my problem is for some reason when im searching for records soon or later it starts changing the name of the Software to Numbers. I have no clue why it is doing this and I am pretty frustrated now as I been researching and reading for 2 days but can not find another rookie that has gone through this issue before. Basically when im searching it starts off good all the records are synchronized with the Software Field on the form but then all of a sudden you will start seeing that the names will randomly start getting changed to Numbers. Can someone please help me? Thanks

10-11-2009, 07:06 AM	#2 (permalink)
JayJ24 Registered User Join Date: Jan 2008 Posts: 49 OS: Windows 7	Re: Access 2007 Combo Box Help Well im thinking i find my problem but not to sure I had the control source set for the search box and then the same control source set for the software_box Could that have been my issue?