I normally do battle with ASP on the Internet, but none the less I cannot believe I am having problems with this.
I have a table with names and adresses and stuff which is displayed in a regular form, we'll call it MyForm1. I need to search it for a postcode which is chosen from a dropdown box in another form, we'll call it MyForm2. In the UK there are only 121 unique town postcodes, some one character, some two. Anyway I have got the search thing working fine, it finds a postcode in the table and a message box pops up to let me know it has. So far, so good. Trouble is, no matter how hard I try, I can't shift the focus onto the previous form and show the record which matches the postcode.
I thought all I had to do was use SetFocus and DoCmd.GoToRecord for it to work. Obviously not. Any ideas?
I have a table with names and adresses and stuff which is displayed in a regular form, we'll call it MyForm1. I need to search it for a postcode which is chosen from a dropdown box in another form, we'll call it MyForm2. In the UK there are only 121 unique town postcodes, some one character, some two. Anyway I have got the search thing working fine, it finds a postcode in the table and a message box pops up to let me know it has. So far, so good. Trouble is, no matter how hard I try, I can't shift the focus onto the previous form and show the record which matches the postcode.
I thought all I had to do was use SetFocus and DoCmd.GoToRecord for it to work. Obviously not. Any ideas?