I have a form that has a list box. You chose from the list and it populates text boxes that are used in two queries. I have a subform that uses these two quires for its data. The subform does not update or change unless I close the form and reopen it then the info appears in the subform. I tried a open query macro it just opened the query on top of the form. I tried a requery macro but it gives me an error control or control name not on form. I tried to set the focus on the form by building the following statement in the (On Current) of the main form I tried in (After Update) as well
Forms![Adjwhocan]![Whocan subform].Setfocus
Forms![Adjwhocan]![Whocan subform].Requery
No luck. I tried what DougP suggested I saw his reponse to a simular question but no luck. I know my naming convention isnt the best but I have checked my spelling.
Can anyone help? I would appreciate it
Thanks
Tmat
Forms![Adjwhocan]![Whocan subform].Setfocus
Forms![Adjwhocan]![Whocan subform].Requery
No luck. I tried what DougP suggested I saw his reponse to a simular question but no luck. I know my naming convention isnt the best but I have checked my spelling.
Can anyone help? I would appreciate it
Thanks
Tmat