Search results for query: *

I have a simple form/sub-form that shows data from two related tables. I have a command button that adds 15 new records to the table that is displayed by the subform. The command button then calls requery on the subform so it will display the fifteen new records. But the subform will only...

I have a simple form/sub-form that shows data from two related tables. I have a command button that adds 15 new records to the table that is displayed by the subform. The command button then calls requery on the subform so it will display the fifteen new records. But the subform will only...

I found a solution! But its not a good solution. Can anyone explain why this is happening? I noticed that if I press F9 after I ran my command button it usually would refresh the subform. But I had to wait a couple second before pressing F9, or else it wouldn't work. So I added one line of...

Hi, Thanks for the suggestion. I tried that too, but it still never refreshed. In my original example, my code changed the recordsource. In this simplified version I don't change the recordsource, but I manually call requery. Both ways, it won't refresh the display until the user...

Hi, Thanks for the response! Unfortunately, I'm still having the same problem. I have now created a simplified version of my problem in order to narrow down my problem and better communicate it. Here is the new version of my situation which has the same problem: I have two underlying...

Hi, I have a form/sub-form. On the main form the user selects a record, and then clicks a command button which will insert fifteen new records in the related table which is displayed by the sub-form. The user can then edit those fifteen rows in the subform in order to provide additional...