Search results

I have combobox displays the users' first names and last names. When I select the drop-down control and after I select another user, it only shows the last name of the user I selected. tia, cmc

I have a form with multiple tables that are linked by a userID [fid]. My first table is my list of teachers with the following fields: [fid],[fname],[lname]. All of my other tables have the following fields: [fid],[o1],[o2],etc. When I first open the form, I see my first teacher, but none of...

Once again thanks for your help. If you can't help me resolve, I certainly understand. The userid is an integer. I tried it your way and got no error, then I changed it to see if the userid was being properely passed.

I placed the following code in an EventProcedure in the On Current section of form2's events. I changed your code, so that I could see if the bookmark criteria was being properely read. I have verified that the fid (userID) has one record with the correct fid in the linked table to form2...

Once again thanks again for the help, all is well with my request. However, upon further review, what I really need is for the next form to check for a previous record for the linked table based upon userID. Since I am new to VBS I'll write the code in a way I hope displays my meaning. if...

Thanks very much for the reply. I have to admit to being a VBS newbie (although I am a long time programmer in other langs), so I am not sure exactly how to deploy your code. If you wouldn't mind being a little more specific... This codes works as suspected...

I have several forms in an Access db and have a command button that closes the current form and opens the next form. I need the command button to open the next form with the current form's user ID in a new record for the next form. tia, cmc