Good Afternoon All;
Is it possible to have an append query enter some default text in a table should the original text on a form be null?
For Example:
My Query has the current criteria:
Field: Expr1: Forms!frm_Postcharge_main!m_surname_send
Appending to: word_m_name_send (on: tbl_Postcharge_main)
So what I want to do is, if 'Expr1' above is null, automatically append 'No_Value' to tbl_Postcharge_main without prompting the user to enter anything.
Your Help On This Would Greatly Be Appriciated J
Regards
Tor Fey
Is it possible to have an append query enter some default text in a table should the original text on a form be null?
For Example:
My Query has the current criteria:
Field: Expr1: Forms!frm_Postcharge_main!m_surname_send
Appending to: word_m_name_send (on: tbl_Postcharge_main)
So what I want to do is, if 'Expr1' above is null, automatically append 'No_Value' to tbl_Postcharge_main without prompting the user to enter anything.
Your Help On This Would Greatly Be Appriciated J
Regards
Tor Fey