G
Guest
I have a subform that is in a loacted in my form. The data for the subform
comes from a query that I have created and the query is from a table.
The process is I open the Main form and a Delete Query runs deleting all
data in my table. When I enter the values using combo boxes in my main form,
calculations are done which then are appended to this table. Then my SubForm
query runs which should populate the subform, but doesn't. I use a
docmd.requery "SubFormName" and nothing.
The strange thing is when I close and then reopen the form the subform has
data, but should be blank since I ran a Delete Query on form load. When I
requery this the subform updates to no records. Then when I run my
calculations, populate the source table and run requery nothing happens.
But... then when I close the form reopen again the data is there that should
have appeared before when requery.
What is going on with this subform? I know the data is there but not
showing up in the subform.
comes from a query that I have created and the query is from a table.
The process is I open the Main form and a Delete Query runs deleting all
data in my table. When I enter the values using combo boxes in my main form,
calculations are done which then are appended to this table. Then my SubForm
query runs which should populate the subform, but doesn't. I use a
docmd.requery "SubFormName" and nothing.
The strange thing is when I close and then reopen the form the subform has
data, but should be blank since I ran a Delete Query on form load. When I
requery this the subform updates to no records. Then when I run my
calculations, populate the source table and run requery nothing happens.
But... then when I close the form reopen again the data is there that should
have appeared before when requery.
What is going on with this subform? I know the data is there but not
showing up in the subform.