subform question

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup in Continuous form 0
VBA code returns no records hwenKey ID is added 14
Filter main form to records with no related records in subform,maintain updateable recordset 4
Duplicate record in Form and Subform 0
OpenForm and Navigate to Subform Record? 1
Update field in related table 5
Filter subform with combo box on main form 1
Problem refreshing subform 2

Top