Code:
DoCmd.OpenForm "frmVendor"
bbobely
Last Activity: Nov 9 '10, 09:17 PM
Joined: Aug 2 '10
Location:
-
bbobely started a topic Why doesn't Onclick event doesn't fire for subform after changing its sourceobject?in AccessWhy doesn't Onclick event doesn't fire for subform after changing its sourceobject?
I have a generic subform control (subMain) whose sourceobject changes based on a combobox selection. Each sourceobject is a separate subform. These subforms (subsub1, subsub2 etc) have a field whose onclick event is. When subMain is loaded its default sourceobject is subsub1 and the onclick event works fine. However, when I make a new selection in the combobox and change subMain's sourceobject to subsub2, subsub2's... -
Thanks for the help, maybe I can provide a little more clarification. Both subforms are unbound. The records in subform 2 should change depending on which record in subform 1 is active. I tried to accomplish this by using a textbox as an intermediary to capture the active record number from subform 1 (the requests_query subform in the code above). A query then runs based on the changing active record number of subform 1 captured in the textbox; I... -
The basic problem is that I have a subform (subform 2) which doesn't update. Subform 2 is based on a query. The query uses a textbox to capture the active record number from subform 1. I tried to use the afterupdate property of the textbox to run the query when the active record in subform 1 changes. But apparently the afterupdate property is not working properly because I stuck a msgbox in there and it didn't pop up (see code above). Although the...Leave a comment:
-
I stuck a msgbox in the afterupdate event of the text box control and it didn't come up, so I'm assuming this code isn't executing at all. The textbox gets it value through this:
and this is the code in the update event property:Code:=[Requests_Query].Form![Request Number]
...Code:Private Sub Text_AfterUpdate() Dim RSQQueryName As String MsgBox ("sux") RSQQueryName = "Request_Skills_Query"Leave a comment:
-
Subform won't update on parent form, but will elsewhere
Hi,
I've built a sequence that works thusly:
User chooses a value from a combo box. This causes a query to run displaying records with a field value matching the combo box in subform 1. Then, the record ID of whichever record is active in subform 1 is used to populate a text box. This text box has its after update property enabled that runs a second query which should populate a second form by matching the record id to entries in a...
No activity results to display
Leave a comment: