Combo Boxes

[JezBullen]

Hi

I have a table called Images with fields PartNo & ImageLocation

I have a form with a Combobox that the user will use to select the right part, and I then need to display the ImageLocation in a text box when the user changes the part

I've tried the DLookup method among others but not having much luck

Hopefully someone can help

Many Thanks
J "Only Another Month in IT" B

 

[JezBullen]

Solved it.....ignore me

 

[Crowley16]

what you need to do is to create a combo box
and in it's recordsource, put a sql statement that selects BOTH fields:

select PartNo, ImageLocation from Images;

and then you need to set the boundcolumn property of this combo box to the ImageLocation, this means the combobox's value will be the ImageLocation.

and you need to set the column width to XXcm, 0cm this is so that the combobox will only show the PartNo and not the ImageLocation.

 

[JezBullen]

many thanks

is it possible to do the same with a Data Access Page do you know?

Thanks