Data Entry Form

R

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).
 
J

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).
Click to expand...

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]
 
R

Ray S.

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

John W. Vinson said:
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).
Click to expand...

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]
Click to expand...
 
J

John W. Vinson

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

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

John W. Vinson [MVP]
 
Top