Dear Professionals,
Please I need help again. I have an append query that I run every month on a form using a button(with vba). Append query is named (AppData). On that form(FormA), I have an unbound field(with date picker)(say:Fie ld1) and the record source for my form (FormA) is Table1. This Table1 has a field for date called (Field2). This Table1 is where my data append to.
My Request:
On my (FormA), Any month I want to append to Table1, I want to pick a date from (Field1) and the result should reflect on (Table1:Field2) based on number rows data append to.
I can append using vba but field2 on Table1 (which is for date) always remain empty.
Please help me.
Thank you sir
Please I need help again. I have an append query that I run every month on a form using a button(with vba). Append query is named (AppData). On that form(FormA), I have an unbound field(with date picker)(say:Fie ld1) and the record source for my form (FormA) is Table1. This Table1 has a field for date called (Field2). This Table1 is where my data append to.
My Request:
On my (FormA), Any month I want to append to Table1, I want to pick a date from (Field1) and the result should reflect on (Table1:Field2) based on number rows data append to.
I can append using vba but field2 on Table1 (which is for date) always remain empty.
Please help me.
Thank you sir