How do I get a partial match?

[tkip]

Try using the keyword "like" in your query.

"WHERE table1.recordID Like "*" Forms![InputForm]!cmbRecordID "*" "

May be that's what you are looking for.

[NeoPa]

Try using the keyword "like" in your query.

"WHERE table1.recordID Like "*" Forms![InputForm]!cmbRecordID "*" "

May be that's what you are looking for.

I see where you're going, but I don't think this would work in the current situation.

We always welcome any and all attempts to help out though - Welcome to Bytes!