Using a form to implement a query

[Cass]

Name: Capture.JPG  Views: 23  Size: 107.9 KB  ID: 34873" class="thumbnail" style="float:CONFIG" />
Hello,
I'm trying to design my form so you can type in what you are searching for in the field instead of the popup.
Any ideas?

I'd like to be able to type data into the fields circled in red, instead of the blue popup.

[CJ_London]

what does your query sql look like at the moment? it looks like it is trying to reference the form so not clear to me what the issue is. And can you confirm you have a control called UNIT in your ImpulsData_1 form - i.e. it is not on a subform.

[Cass]

Thank you Ajax for your response! I have a database with
1-table of data, containing columns for waveform, BIL, bushing etc. and then corresponding columns that just contain data that won't be in my query but is the data I'm search for (resistance values, etc)
2- the query code is below (SQL view)

SELECT ImpulseData_1.UNIT, ImpulseData_1.CONFIGURATION, ImpulseData_1.[TEST FLOOR], ImpulseData_1.WAVETYPE, ImpulseData_1.BUSHING, ImpulseData_1.[BIL bushing being impulsed number], ImpulseData_1.MVA, ImpulseData_1.[IMPEDANCE use Numbers only], ImpulseData_1.[CHOP TOWER STAGES], ImpulseData_1.[FRONT R], ImpulseData_1.[TAIL R], ImpulseData_1.NOTES
FROM ImpulseData_1
WHERE (((ImpulseData_1.UNIT) Like "*" & [Forms]![ImpulseData_1]![UNIT] & "*") AND ((ImpulseData_1.CONFIGURATION) Like "*" & [Forms]![ImpulseData_1]![CONFIGURATION] & "*") AND ((ImpulseData_1.[TEST FLOOR]) Like "*" & [Forms]![ImpulseData_1]![TEST FLOOR] & "*") AND ((ImpulseData_1.WAVETYPE) Like "*" & [Forms]![ImpulseData_1]![WAVETYPE] & "*") AND ((ImpulseData_1.BUSHING) Like "*" & [Forms]![ImpulseData_1]![BUSHING] & "*") AND ((ImpulseData_1.[BIL bushing being impulsed number]) Like "*" & [Forms]![ImpulseData_1]![BIL bushing being impulsed number] & "*") AND ((ImpulseData_1.MVA) Like "*" & [Forms]![ImpulseData_1]![MVA] & "*") AND ((ImpulseData_1.[IMPEDANCE use Numbers only]) Like "*" & [Forms]![ImpulseData_1]![IMPEDANCE use Numbers only] & "*"));



3-I'm either looking into having the user enter it into the field and run a query,



4-or at least, and probably the most simple, get rid of the table and data ref and just have it refer to a field


As for referring the field entry in my form, that didn't seem to work either.

[CJ_London]

Are all the controls unbound? is ImpulseData_1 the main form or a subform?

[Cass]

Are all the controls unbound? is ImpulseData_1 the main form or a subform?

Thanks!
Actually, I finally stumbled on the answer by referring to the form text box. I wasn't entering it as "txtImpulse" for example in the query.