Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2007

    Question Unanswered: Getting Error on Form: Cannot add or change - required in tbl_XXX

    I have seen this error before but not for sometime.

    I thought I had everything set up correctly in my relationships.

    Can someone look at this and tell me what I have done wrong.

    I have form that opens up. The clerk will select The Hub > The Customer > Enter the date doing this > Number of Packages Sampled > (Then if any discrepencies will list the Parcel ID, Zip Code, If it is a Standard A or Standard B and the weight in the subform.

    This db has 4 tables:
    CustomerID > AutoNmbr > PK
    CustomerName > Text
    HubID > Number > FK to tbl_Hubs

    HubID > AutoNmbr > PK
    HubCode > Number
    HubName > Text

    EntryID > AutoNmbr > PK
    Date > Date/Time
    Qty_Packages > Nmbr
    CustomerID > Number > FK to tbl_Customer

    PID > AutoNumber > PK
    EntryID > Number > FK to tbl_DataEntry
    ParcelID > Text
    ZipCode > Text
    IndiciaA > Yes/No
    IndiciaB > Yes/No
    Weight > Number > Double

    These will then post to the proper tables.

    Any help with this would be great.
    Attached Files Attached Files
    Last edited by ajames420; 08-02-07 at 10:26. Reason: Wrong Database in ZipFile

  2. #2
    Join Date
    Jun 2007
    Is there anyone that can help me with this? I have posted this on 3 different sites in the last 2 days and it seems like this question or issue gets bypassed/ignored.

    I am looking for any help on what I may have done wrong.

  3. #3
    Join Date
    Jun 2004
    Seattle, WA
    Probably because you aren't saying where the error is. My guess would be that check your queries that this form is on, maybe something got changed.
    My Blog

  4. #4
    Join Date
    May 2004
    New York State
    The reason I didn't reply, although I downloaded it and unzipped it, and played with it, is because you blocked all the menus, etc., and I have a limited amount of time to play with it. Maybe if you open all the menus, and make everything available, someone will have a much easier time of troubleshooting.


  5. #5
    Join Date
    Dec 2004
    Madison, WI
    I'm taking a quess here and stabbing in the dark as you didn't really specify the error you get or where you get it, but your subform is linked to the main form by EntryID but you don't have an EntryID field on your main form (USPS Customer Audits). Is that possibly the problem?

    Could you please relate what error you are getting and where you get it?

    It was difficult to diagnose without this information. Also, should this: Me.cbo_CUSTOMER = Null be this: Me!cbo_CUSTOMER = Null? Again, stabbing in the dark.
    Last edited by pkstormy; 08-02-07 at 21:19.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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