subform question

  • Thread starter Thread starter Bob Hughes
  • Start date Start date
B

Bob Hughes

I have a main with no record source and a subform whose record source is a
temporary table. When I update the table from the main form, the subform
does not show the new information.
This is what I do
strSQL = "INSERT INTO …………"
CurrentDb.Execute strSQL, dbFailOnError
DoCmd.Requery

The table is updated properly, but not displayed in the subform

How do I get the subform to display the table content? I'm using office 2K

Bob
 
Back
Top