Access 2007 Combo Box

[Guest]

I am trying to link a combo box in a form so that it will pull up the record
when it selected from the list or the numbers are typed in. The values from
my table are shown in the drop down menu but I cannot get Access to go to the
selected record.

Any help is appreciated.

 

[Guest]

Have you tried using the wizard for the combobox? This should do the trick.
Make sure the wizardbutton is 'on' in the toolbox and then place a combobox
follow the wizard steps.

Also make sure you are referencing the correct fieldvalue from your table.
So if column(0) is the id-column make sure these values are in your table.

And finally make sure the combobox is 'unboud' so it should not have a
controlsource but it should have a recordsource.

hth

 

[Guest]

When creating my form in design view, the wizard does not give me the option
to "find record on my form based on the value in my combo box". I get this
option if I use one of the templates that Access provides but they do not fit
my needs as I can not arrange the boxes to my choosing. Is there a way I can
edit the templates or have the wizard prompt me with the command stated
above?

 

[Guest]

i had the same issue about a week ago. all u will need to do is pull up the
TABLE in design view. then scroll down to the column header where your
selections from your combo box will go. change the "Data Type" from "Text" to
"Look Up". this will open the Look Up Wizard for you. you should already have
a seperate table that contains only the list that you want displayed in your
drop down or combo box. (you will have to also change the "Data Type" from
"Text" to "Look Up" in the table that has your selections in it as well.)
select that table as the look up table and follow the wizard. make sure to
indicate which field in your table you want your selections displayed in when
the wizard asks. once complete this should allow you to be able to select the
choices in your combo or drop down box.
i hope this helps!

 

[Guest]

I tried it again to see if I got the same situation. Indeed when I had
nothing on my form I didn't get the option.
What I did was I created a new form based on a simple table with two records
and then added a combobox with the wizard activated. At that point the wizard
presented me with the third option as well.

Goa ahead try creating a new form based on your source. Create the combo
using the wizard. When it works copy the code from the wizard. Delete the
form you've just created and past the code to the original form in the after
update event of the combo (ofcourse adjusting the name for the combo)

hth

 

[Paul Shapiro]

I don't know for sure in current versions, but in older Access versions the
form's record source had to be just a table name for the wizard to offer
that 3rd option of finding a row. If the record source was SQL, that option
was not offered.