Recent content by wehoscottward

Hi, Linq. Never mind, I figured it out. I needed to make the ID field which is an AutoNumber field in my table into the Primary Key field. Once I did this, all records were given unique numbers rather than duplicated numbers and my problems were solved. Thanks again for all your help...

Hi, Linq. Unfortunately, I spoke too soon! The code you gave me is working and creates a new record with the 5 different fields copied from the old record into the new record. The problem I’m having now, is that the ID field which is programed to generate an AutoNumber, which should be unique to...

Oh, you're right! The field name was slightly different in my form. I changed it and everything works perfectly now. I'm so happy! Thanks so much! Scott

Hi, Linq! Thanks so much for your reply! This works great except for 1 field—the Assigned_WRCA field. If I copy the code for the 1st 4 fields everything works perfectly. When I add the code for the 5th field (Assigned_WRCA), I get runTime error '2424" It says that it can't find...

Hello—I’m not having much luck with my Goggle research. I would like to create a command button on my form that copies values from 5 fields in the current record into a new record—leaving all the other fields blank except for the new record ID. The fields that contain the data that I want copied...

Hi, Paul. Thanks so much for your reply here. You’ve helped me a lot in the last week. What ended up working for me here was to link my subform to my combobox using the record ID (rather than the member’s name, which is how I had it linked). As we know, the record ID is unique for each record...

Hi, Bob. Thanks for your response. The only code I have in my combobox [Combobox2] is the following in the Row Source Field. SELECT [Find Member's WRCA Hx].Referral_Date, [Find Member's WRCA Hx].Member_Name, [Find Member's WRCA Hx].Member_ID, [Find Member's WRCA Hx].Account, [Find Member's WRCA...

Hello. My combobox is not working correctly. When I select one of the dropdown items in the combobox it always defaults to the 1st item on the list. I want to be able to select any of the dropdown items on the list. Any help would be appreciated. Thanks, Scott

Hi, Paul. Thanks--that seemed to solve that problem, however, there's a new problem. I get a new Run-time error '2424': The expression you entered has a field, control, or property name that Microsoft Access can't find. Also in the subform, the member's name is populated correctly...

Hi, Paul. Here’s the code I entered however, I’m getting an error message. Private Sub Combobox2_AfterUpdate() If Me.Combobox2.ListIndex <> -1 Then Me![WRCA Data Entry Form].Form.RecordSource = "SELECT [Member_ID] FROM [WRCA Data Table 2013] WHERE [Member_ID]= " & Me.[Combobox2] Me![WRCA...

Hi, Paul. Thanks so much for this! I have 2 questions, however: My Combobox = [Combobox2] My Subform = [My WRCA Data Entry Form] The Field from my dropdown list = [Member_ID] What is TheTable ? What is SomeID ? Thanks, Scott

Hello. I would like to select a record from my combobox dropdown list and have that record populate in my subform. Currently, I’m only able to select the 1st record at the top of the dropdown list to appear in my subform. But I would like to select any record from the dropdown list and have it...

Actually, what worked for me is: Me.Combobox2.Value = Null Me.Combobox2.Requery Thanks.

Hello. I have a comboxbox that runs a parameter query when the user clicks on the combobox. The combobox works great and generates a dropdown list of all records that matche's the query paremeter. Now I want the user to click on a command button that resets the combobox so that the user can...

I’m on steps 3 and 4 of your instructions above. 3. Save the Query and then set this as the RecordSource for the subform. Done. 4. . On Click of the button, just requery the subform. Im not having any luck with this part. I can see how to add code to On Click of the button, but I’m not sure...