show multiple records

[EddP]

Hello
I am using one table with all different information in each field except for a date field. I would like to see all the same requested dates on my form using a combobox from a subform. if the table name is Employee Records and the field I want to show all similar information from the table is called Scheduled Date how do I write this?

 

[jdraw]

EddP,

Tell us about the "business" this database is intended to support. You mention Employee Records, but it would be helpful to you and readers if you could "flesh out" (add some meat) to you description.
Use the old who, what,when,why approach to tell us about these Employee records and how the pieces fit within your business.

Get your tables and relationships established and tested before jumping too quickly into physical Access.

 

[EddP]

thank you , my database table is a running list of employees at a particular site. Each week I append to the table records of new hires, moves and terminations. Each of the fields has information pertaining to telecom, electronics, scheduled start dates, etc. I can use a combo box to look up records for employee number or name or basically singular records but I wanted to look up the Scheduled start date and have the list show in a sub from datasheet view. The current working form I didn't want to use a continuous form because I don't want to see all the records but just the ones I am asking for.
In the table the scheduled start date re-occurs and I wanted to only see one date in the combo box but see all the records in the subform set as datasheet.

 

[June7]

You want a combobox to list all the unique dates from table Employee Records?
Possibly: SELECT DISTINCT [Scheduled Date] FROM [Employee Records] ORDER BY [Scheduled Date];

What would be purpose of combobox - to select filter criteria? Should be UNBOUND.

BTW, advise no spaces nor punctuation/special characters (underscore only exception) in naming convention. Better would be Scheduled_Date or ScheduledDate