Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Atlanta, GA
    Posts
    92

    Unanswered: Query question...

    I have a form that has multiple queries. Each query produces a specific list of items, and when the table is manually filled, it shows the amount of each item ordered, on hand, etc..
    My problem is that when I try to enter in an amount into one of these fields on the form, it does not add a new line into the table, which gives me the "a related record is required in tblBOMmain" error.
    How does one go about adding a line to a table when a specific line of a query is edited?

    Any help would be truly appreciated.

  2. #2
    Join Date
    Sep 2003
    Location
    Atlanta, GA
    Posts
    92
    I have located the issue with my problem. One of the "Not Shown" elements in the query is not being filled with the correct number.
    I figured this out by Showing all of the fields and running the query.
    Last edited by inzzane; 10-17-04 at 19:23.

Posting Permissions

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