Recent content by TasCat09

My bad, syntax error. FYI, correct syntax was DoCmd.Requery (FormName) . Requery instead of Refresh but works great.

Good morning I was hoping someone could help me understand why my VBA code cannot refresh a userform. I am using Access 2019 and have a simple database that includes a continuous form. Part of the form is a field to display a field from a table. The field is either set to no or yes and is...

Hi All Thank you all for your advice on this problem. I ended up resolving it and the out of range issue that I got next by adding the number of elements in the array in parentheses. In regard to the question from jdraw, I was just testing my ability to deal with recordsets originally. I have...

Hi All I am hoping to present the user with a msgbox at the end of an sql update query that advises which records were added. In order to do it I need to be able to add each row in a recordset to an array variable. Can anybody explain why the first piece of code works for me (msgbox each...

Yep, doesn't seem to fire when the focus changes from one record to another on a subform which is what I need.

Hello I am trying to update the caption of a number of buttons on a form. I can update the captions with the use of another button so I know the VBA code is correct. However, I cannot find an event that I can attach the code to in order to automatically update the buttons. The names of the...

Thanks Stopher That worked like a charm. I also had success with the following: recID = DLookup("[ID]", "RECIPES", "RecipeName = '" & Me.txtRecipe & "'")

Hello Can somebody help me understand why the top line of code works OK but the second doesn't? recID = DLookup("[ID]", "RECIPES", "RecipeName = 'chow mein'") recID = DLookup("[ID]", "RECIPES", "RecipeName = '" & Me.txtRecipe & "')" Where txtRecipe is a text box on the current form that's...

Thank you Sneuberg That does exactly what I want. I was not aware I could use the column property like taht. Thanks again

Hello and thanks for allowing me to post. I am new to access and am looking for some help from you guys who are much more experienced than me. I am developing a recipe database and on one particular form I want to set the value of txtIngredient1(text box) as the IngredientName(field in...