Try to use onKeyPress() event handler instead of the onChange() method.
*Pay attention to write in eq() method the Field key and not Field Name.
*That the database name is written correctly.
Best of luck,
thank you for your reply.
this search returns results with the following code.
This field was created by an insert function in the code.
this search doesnt return anything and was this code
wixData.query("BOOKING").eq("Booking Number", $w('#BookingNumber').value)
This field was created when the form submission button was created.
As seen the field names look different. The field created by code is enclosed in square brackets. The field name created by the form looks different. I'm guessing i'm accessing the field name incorrectly but not sure what the correct syntax should be
Because you used the field name instead of the field key.
Thank you both. Got there in the end :)