Combo Box wizard does not provide "find a record on the form" option

  • Thread starter Thread starter Tony Austin via AccessMonster.com
  • Start date Start date
T

Tony Austin via AccessMonster.com

I want my combo box to select records on my form from an underlying table.
My combo box wizard does not give me the (third??) option of allowing this.
I know I can write the code myself but I thought it should be able to be
done automatically. I have spent hours scouring the web looking for advice.
I read in another thread that this could be that there was no underlying
table, I do have one.
Please help.
 
I want my combo box to select records on my form from an underlying table.
My combo box wizard does not give me the (third??) option of allowing this.
I know I can write the code myself but I thought it should be able to be
done automatically. I have spent hours scouring the web looking for advice.
I read in another thread that this could be that there was no underlying
table, I do have one.
Please help.
Click to expand...

You don't get that third option UNLESS the form has a record source.

Set the record source first, then you should be able to add the combo
bos and see that "Find a record..." option.
 
in message:
You don't get that third option UNLESS the form has a record source.

Set the record source first, then you should be able to add the combo
box and see that "Find a record..." option.
Click to expand...

You also will not get the third option if the Record Source is a
direct SQL statement on the form's Properties List. If this is the
case, temporarily make a saved query based on the SQL statement,
assign that query as the Record Source of the form, then run
the combo box wizard. After the combo box is created then you
can change the form's Record Source back to the SQL statement
if desired.
 
Thank you. I didn't know that. My records source was an SQL query. I got
around my problem by adding the code to the after update property manually
but it was driving me crazy trying to figure out why the wizard wasn't
doing what I thought it should.
One more question if I may; Is it possible to have the combo box show
multiple field values before it is selected and dropped down?
 
in message
Thank you. I didn't know that. My records source was an SQL query. I got
around my problem by adding the code to the after update property manually
but it was driving me crazy trying to figure out why the wizard wasn't
doing what I thought it should.
Click to expand...

Now you know.
:-)
One more question if I may; Is it possible to have the combo box show
multiple field values before it is selected and dropped down?
Click to expand...

*Before* being dropped down?
No, the combo box will only show one column before being dropped
down. After clicking on it, yes it can show more than one column.
You can, however, combine different columns into one so it *seems*
like there is more than column. I do this quite often with combo boxes
of names.
 
Back
Top