How use lookup wizard for dates?

[316854]

How does one use the lookup wizard for dates?

It says:


The lookup wizard doesn't apply to fields of this data type.

I want a combo box for dates.

Thanks

[ranman256]

no need for a wizard.
On the cboBox, select the property ROWSOURCE.
click the elipsis box to the right, it will start a query.
choose your data table
choose your field.
close the query.

[316854]

How do I create a combo box without using the lookup wizard?

[316854]

I have a list of unique dates in one table. I have another table that will use a unique date many times. With the latter table, how do I create combo box based on the dates of the table that has a list of unique dates?

[ItsMe]

You can associate fields from tables with your combo box using the Query Builder. This is done through the Row Source property. Other properties to consider are Column Count and Column Widths.

.


Another approach is to use the wizard. Turn the wizard on by highlighting "Use Control Wizard" before adding control to your form in Design View. You can highlight Use Control Wizard by accessing it via the Ribbon. Click the "Design Tab". There will be a group. In the Controls group, there is an option to display more. Use the pulldown button in the lower right hand corner of the Controls group to display more.

[316854]

I found a partial solution. I'm not offered a combination box, but I did make the field restricted to the dates I have listed in another table. I changed the field from Date/Time to Short Text.

I used the lookup wizard.

To my surprise, in design view, the field changed itself from a Short Text Field back to a Date/Time field.

Microsoft, wouldn't it be easier if one could keep the field set as a Date/Time field and allow the lookup wizard to work? Why do I have to change it to something else when it changes back to a Date/Time field anyways? Another thing Microsoft, I don't want a date picker! I want a combination box for this field!

[316854]

You can associate fields from tables with your combo box using the Query Builder. This is done through the Row Source property. Other properties to consider are Column Count and Column Widths.

.


Another approach is to use the wizard. Turn the wizard on by highlighting "Use Control Wizard" before adding control to your form in Design View. You can highlight Use Control Wizard by accessing it via the Ribbon. Click the "Design Tab". There will be a group. In the Controls group, there is an option to display more. Use the pulldown button in the lower right hand corner of the Controls group to display more.

I see what you mean now. I was trying to use a combo box in datasheet view directly in the table. I understand now that I have to use a form for a combo box.

Thank you

[ItsMe]

If you have a combo in a table, what you really have is a lookup field. Lookup fields are not advisable. Create another table (Lookup Table) and use a form in combination with a Combo Box to query your new table. Store primary key values from your new table in Foreign Key fields of other, relative, tables.