Search results

Bob... thanks that worked, now I'll pick it apart & apply it to the remainder of my project. Kudos

pngBill... that sounds workable, I'll try it.

So... maybe there's another way of doing this that I'm missing. The goal is input a fieldID into the unbound control txtFieldID, then the other fields on frmInputFieldID are the fields associated with that particular fieldID. I've tried putting the txtFieldID into a header but this also...

Hi... thanks for the suggestions. Yes if I remove the criteria the problem goes away, but the whole purpose of the FieldIDinput form is to pass one specific record to the second form. To reproduce the error try opening the frmFieldIDinput form

Here's the link: http://wrir4.ucdavis.edu/data/fieldidtest.zip

I have commented out those lines since they actually action on an external form. Commented out the recordsource still doesn't resolve. I've tried to get this VBA form of my query to work but it's not quite correct: Me.Recordset = "SELECT tblFieldIDsPRNUMsNumeric.FLD_ID...

The unbound control is on the original form.

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...

Spot on... that was the bug. Thanks, S

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...