Search multiple fields

[Gregory23]

Dear all,

Would like to know how to create search in VBA that will look for value in multiple fields

Currently using the below but it is only one field

DoCmd.OpenForm "Export", acNormal, , "[DELIVERY NO 1:]=" & InputBox("Enter Delivery no")

Thanks



G

[ranman256]

Normally, you don't search multiple fields.
if you are looking for a persons name, you look in the NAME field. Not other fields.
if you have name in several columns, your table is designed wrong.
that is why there is no function to do this.

[orange]

Unclear of what you might include in multiple fields. You might try the approach used here.