Drop-down list box in Form.

[Tiesto_X]

Hi everyone.
This is my table:http://i376.photobucket.com/albums/oo208/Gvanj/aaa-1.png

This is my form: http://i376.photobucket.com/albums/oo208/Gvanj/foorm.png

You can see two rows into form (or two columns into table) Otpremnica and Radni nalog. I would like to have one drop-down list box insted of two separated rows in form.
When i pick Otpremnica from List box and type something it will update Otpremnica column into table and if i pick Radni nalog and type it will update Radni nalog column into table.

I hope you guys can understand me, coz my English isn't that good and its a bit hard to explain.

Thanks.

 

[Galaxiom]

No need to use photobuclet. This site can deal with attachments by using the Advanced editor.

It sounds like you need to use a Union query for the Row Source of the Listbox.