Forms! simple expression criteria not working

[Julia Boswell]

Folks, I'm probably doing something really stupid, as I've done this sort of
things loads of times and it's always worked fine before, and now I haven't
got a clue what I'm doing wrong....

I've got a bound form with several bound and unbound fields on it. I'm
running an append query from a command button to update a table based on
values the user selects in the fields on the form. Unfortunately whatever I
do, the append query ALWAYS returns no records and I'm completely confused.

The query has 2 expression fields:

Expr1: Forms!frmEmployeeTraining!EmployeeID
Expr2: Forms!frmEmployeeTraining!lstTraining

I've tried changing it to a select query, narrowing it down to one field and
ensuring that the field has a value... I've tried testing it on other fields
in the form. I've ensured that the form is refreshed before the query is run
so that the data is accepted, etc etc. and now I'm stuck.

Like I said, it's probably something I'll kick myself about, but if you
could help, I'd be really grateful!!

Thanks
Julia

 

[Julia Boswell]

All, sorted - it wasn't something I'd done, it was something Access had
done..... I just checked the SQL (should have done that before!) and Access
had added from tblTrainingDue at the end of the expressions, which obviously
wouldn't work as the data was not being extracted from a table!

Thanks anyway.

Julia