Using union Query to subform

[romi]

Dear All..
How to using union query to subform..?
i used union query for combobox to select employee name, shown below picture..



when i close the form, and open form again, field of employee name is blank..


How to solve this problem..?


thank you..

[isladogs]

Please provide the record source used as a sql statement

[June7]

What is the combobox RowSource when the form opens? Do you use code to modify the RowSource after form opens?

[romi]

Please provide the record source used as a sql statement

my sql in row source :

SELECT Q_uniontask.ID, Q_uniontask.Employee Name, Q_uniontask.stardate, Q_uniontask.Enddate FROM Q_uniontask WHERE (((Q_uniontask.Employee Name) Not In (SELECT [Employee Name] FROM [Q_uniontask] WHERE Forms![Task Form]![Startdatefrm] BETWEEN [startdate] AND [Enddate] OR Forms![Task Form]![Enddatefrm] BETWEEN [Startdate] AND [Enddate)));

[June7]

This is a conditional query. The names won't display because they are alias values and their records are not in the combobox RowSource, therefore the alias values are not available for display. This must be expected when using conditional query. This is a known issue with Continuous and Datasheet forms. Many, many, many discussions on this topic. Also known as cascading or dependent comboboxes. Usually requires VBA code to manage.