Access 2003, How to select record from Combo box?

C

Confused

I'm an unable to select a record via a combo box, in help "Find a record by
selecting a value from a list" it says "In the first wizard dialog box, click
the option to find a record based on the value you selected in the list box
or combo box", I don't seem to have this option. I thought that this would be
a simple thing to do.
 
T

tina

the Access combo box wizard will not offer that third option unless your
form is bound to a table, query, or recordset. double check your form's
RecordSource property.

hth
 
J

Jeff Conrad

in message:
the Access combo box wizard will not offer that third option unless your
form is bound to a table, query, or recordset. double check your form's
RecordSource property.
Click to expand...

Tina,

If by recordset you mean a direct SQL statement in the form's RecordSource,
then no, the third option will not appear in that case. Only with a table name
or saved query will the third option appear.
 
P

Paul

tina said:
the Access combo box wizard will not offer that third option unless your
form is bound to a table, query, or recordset. double check your form's
RecordSource property.

hth





Thanks Tina, I was missing the obvious and I didn't realise that the wizard would give you different options dependant upon your selections.
Click to expand...
 
T

tina

you're welcome, Paul, and i hope you noticed Jeff's correction also, so you
don't end up confused by my mistake! :)


wizard would give you different options dependant upon your selections.
 
P

Paul

Jeff Conrad said:
in message:


Tina,

If by recordset you mean a direct SQL statement in the form's RecordSource,
then no, the third option will not appear in that case. Only with a table name
or saved query will the third option appear.

--
Jeff Conrad
Access Junkie
Bend, Oregon


Thanks Jeff, that clears it up even further.
Click to expand...
 
Top