Combo Box question

[cmorton89]

I have a combo box that pulls information from a Query. I would only like it to pull the records that match a particular date that I am using in the current record of the form.

Can anyone help?

Thanks in advance!

Courtney

 

[wazz]

I have a combo box that pulls information from a Query. I would only like it to pull the records that match a particular date that I am using in the current record of the form.
Courtney

- in your query, include the same date field that is on your form
- in the criteria of that date field (in the query) put:
[Forms]![MyFormName]![MyDateFieldName]

 

[cmorton89]

updating combo field each record

I need this combo box to update to the current record date field for each record. Right now all it does is show me the date from the first record I select.

 

[wazz]

in the On Current event of the form:
docmd.requery "MyCombo"