Please help .. form not working as planned

[KCK]

Hi group, I am a newbie to Access and VBA programming. My original post was probably not very specific as it was not answered but I really need help on this!

TABLE1 stores a list of serial numbers and a status field (it contains the word Pass or Fail). The NEWSN table is used to capture new input of serial numbers and a field to indicate if the serial number exists in the first table.

The query based continuous form used to enter the new serial number. Upon entry of the new serial number the form requeries to find the match. If a match is found the remaining fields on the form populate correctly. If no match is found the form does not show the input of this serial number, but it does write the new serial number to the NEWSN table.

How can I get it to keep the new serial number showing on the continuous form and insert a statement into the NEWSN table indicating "No Match"?

Any help would be greatly appreciated!

Thanks,
Kerry

 

[KeithG]

Can you post an example db? I am not to clear on what the problem is.

 

[KCK]

Hi KeithG,

Thanks for responding. I am getting desperate with this project.
Here is a small copy of the database.

Thanks,
Kerry

 

[KCK]

Hi KeithG,

Thanks for responding. I am getting desperate with this project.
Here is a small copy of the database.

Thanks,
Kerry