Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010
    Posts
    186

    Unanswered: Requery after data in entered in subform field

    I have built a Customer/Invoices/Payments database that keeps track of company profit

    I have a mainform with a single record subform to enter data into a table and another subform to view data from a query.

    This subform entry will effect the data in the query once it is entered , so what I would like to do is enter the data, save and requery to have the other subform's query update with the new information before I close the mainform

    I need to be able to see the change in that query before I leave

    The last field to enter is a number field - what event can I use to tell access that I'm finished with my entry, save and requery all the under lying tables and queries?

    Any help/suggestion is greatly appreciated!

  2. #2
    Join Date
    Jan 2012
    Posts
    97
    Can you guarantee that the user will enter and exit the controls in a definite order? If you can then you could run your code from the AfterUpdate event of the 'number field' control.

    The attached file has one table with one field, one form bound to this table and one listbox that displays data from a query based on this table. You can enter a value in this text box and then click the 'Save' then 'Requery' command buttons. The listbox will then update.

    One thing to note is that if you are referencing a control on a sub form you must reference it through the main form, i.e. forms!mainformname!subformname!controlname rather than forms!mainformname!controlname
    Attached Files Attached Files
    Hope this helps,

    Dave.

    _____________

    Access 2000 User

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •