Search results

Thanks arnelgp!! works great and I understand it

I will try to explain. I have a PCB type. There could be 100 of them so 100 serial numbers of the same PCB. As a PCB gets put in the next assembly up I want the main assembly to record the serial number of the PCB installed. The complexity comes because throughout the main assemblies life a PCB...

Its just one database I am a bit new to this so am assuming from arnelgp response that where Instr("|" & field1 & "|" & field2 & "|" & field3 & "|" & field4 & "|" & field5 & "|", "|" & Forms!FormName!textbox & "|") > 0 is the criteria in the query? Does it go in each criteria for all 5 fields?

I have a database with 5 fields, each field contains serial number records. The same serial number can appear in one or more fields (can be duplicated) I need to make a query that if I enter a single serial number (ideally from a form), the query searches the whole database and reports the only...

Thanks guys. Bit new to this. Appreciate the help. So in my second level table if I need users to only select certain options (the PCB names) how do I achieve that? Do I use a value list?

I have a one field table that has PCB names recorded. I have another table with several fields one of which is a lookup field to select one of the PCB names from the first table. This populates the PCB name OK. I have a query built on the 2nd table that reports 4 fields including the PCB names...