Hi
This seems so simple but I cannot figure out what is going wrong.
I have a for "FImportUI". It has a textbox and a list box. In the properties, I have given them meaningful names "DateInput" and "TimeInput".
I have an append query that I would like to append the values of the form above to columns of the destination table.
So in my query I have the following:
Field: Expr1: "Date"
Table:
Sort:
Criteria: [Forms]![FImportUI]![DateInput]
This is the same for the list box (with the name appropriately changed to [TimeInput]).
I am running the query through a command button so I enter the values into the form FImportUI and click the button to run the append query but it tells me it is going to append 0 Rows (There is data to be appended for sure).
Can anyone suggest what might be wrong with this set up??
Thanks in advance.
Craig