Search results

This is a recurrent error that bugs the cr** out of me. Sometimes this form works great and then for some reason it fails. The form's record source is a query which runs on an unbound field's Update event: The 2105 error occurs when the form loads and it tries to setfocus on the queries input...

I have the following query which works excellently to populate my form, using the criteria [txtFieldID] from my form. SELECT tblFieldIDsPRNUMsNumeric.FLD_ID, tblFieldIDsPRNUMsNumeric.PRNUM AS Project, tblFieldIDsPRNUMsNumeric.prnum_num, food_master.pesticide, food_master.commodity FROM...

I have a query which is the record source for a form, this query references an unbound text box txtFieldID. SELECT tblTrials.FLD_ID AS FieldID, tblTrials.PRNUM AS prnum, IIf([prnum] Like "A*",Mid([PRNUM],2,5),IIf([prnum] Like "b*",Mid([PRNUM],2,5),[prnum])) AS prnum_num FROM tblTrials WHERE...