Jarekb
Last Activity: Jan 22 '07, 08:44 PM
Joined: Jan 9 '07
Location:
-
The problem I had was not knowing that you could click the "..." button in the properties and select code builder. Once I figured this out, I just added Me.Requery in the code for On Change. Now it works fine. Does it matter if I put that code under On Change or After Update events?... -
Thats a bit confusing since it looks like the whole code of the form. I'm just using the design view to create this form.
I tried creating a macro that just has Requery under Action and nothing in the control name field. In the sub form's properties under the events tab, I set this macro to the afterUpdate field. This works when I open the subform separately, I change the status to processed and after clicking elsewhere the record...Leave a comment:
-
Problem Getting Requery to work
I've been searching around for a bit and can't find a solution to this problem. I've got a subform that show a list of requests that need to be processed in datasheet view. One of the fields on the subform is a status which is a combo box with three choices (pending, withdrawn, processed). The subform shows the requests that have pending in the status field. When someone changes that status to something besides pending I'd like that record to automatically...
No activity results to display
Leave a comment: