S
Steven
I have a query that one of the fields keys off a Textbox in a form.
Form = frmLU
Field in Query: PeriodClosed
Field in Form: tbPeriodClosed
Field PeriodClosed value for a record in the table may be either Null, or
have a value like 200607 or 200608 ie( YYYYMM). It is a Text Field.
Now I want to query the records that = the textbox even if it is Null.
Criteria: [Forms]![frmLU]![tbPeriodCleared]
The ones who have a value will return but if the textbox is null then no
records will return. How do I fix that.
Thank you,
Steven
Form = frmLU
Field in Query: PeriodClosed
Field in Form: tbPeriodClosed
Field PeriodClosed value for a record in the table may be either Null, or
have a value like 200607 or 200608 ie( YYYYMM). It is a Text Field.
Now I want to query the records that = the textbox even if it is Null.
Criteria: [Forms]![frmLU]![tbPeriodCleared]
The ones who have a value will return but if the textbox is null then no
records will return. How do I fix that.
Thank you,
Steven