Data Entry Form

[Ray S.]

OK, what am I doing wrong here?
I have a data entry form with an unbound text box named Invoice_Date. It is
formatted for Short Date and has the input mask 99/99/0000;0;_
I want it to set the results of a column on a select query.
The column is Date: [Forms]![frm_Run_Reports]![Invoice_Date], but nothing
shows up when I run the query (with the form open and the box filled in).

 

[John W. Vinson]

OK, what am I doing wrong here?
I have a data entry form with an unbound text box named Invoice_Date. It is
formatted for Short Date and has the input mask 99/99/0000;0;_
I want it to set the results of a column on a select query.
The column is Date: [Forms]![frm_Run_Reports]![Invoice_Date], but nothing
shows up when I run the query (with the form open and the box filled in).

Please post the SQL of the query.

Note that Date is a reserved word, and Access may be confusing it with the
builtin Date() function.

John W. Vinson [MVP]

 

[Ray S.]

Sorry for the trouble...I figured it out...it was something so simple that
I'm embarrassed to mention it.

OK, what am I doing wrong here?
I have a data entry form with an unbound text box named Invoice_Date. It is
formatted for Short Date and has the input mask 99/99/0000;0;_
I want it to set the results of a column on a select query.
The column is Date: [Forms]![frm_Run_Reports]![Invoice_Date], but nothing
shows up when I run the query (with the form open and the box filled in).

Please post the SQL of the query.

Note that Date is a reserved word, and Access may be confusing it with the
builtin Date() function.

John W. Vinson [MVP]

 

[John W. Vinson]

Sorry for the trouble...I figured it out...it was something so simple that
I'm embarrassed to mention it.

Ego absolvo te, filius meus... <g>

John W. Vinson [MVP]