Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subform doesn’t update or requere

Status
Not open for further replies.

Tmat

Technical User
Jul 22, 2000
27
US
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
 
a few options based on what you are trying to do and which event you place it in

me.refresh

docmd.requery
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top