Help with access before i kill myself

[joantbak]

ok i just wish to create a simple query which will ask a user to select an item from a list and then enter a date to run a selection query.

The fields in use are called 'JOB NAME'(text) and 'JOB DATE'(dd/mm/yyyy)
JOB NAME should also only list distinct entries in a list box for the user to select.

I have created the date entry diologue box for JOB DATE easy enough.

Help files and manual says it can be done but don't show how, I am kinda new to access (having not used for around 10yrs, used SQL a little but that don't help as access does not use correct sql) and i'm ready to start breaking things.

please help someone...

 

[lupins46]

The rowsource for your list box (not a combo box?) should be something like:

Select distinct [Job Name] from thetablenamehere