Results 1 to 3 of 3
  1. #1
    Huddle is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jun 2010
    Posts
    318

    Locked field used for lookup only. Set query where new record can be added.

    I have a field name "Responsibility" that I want to use as a status field only. It is just to tell us who is responsible for that record.



    I am using two tables "Tbl_WO_Log" and "Tbl_Building_Asset_List". The building asset list table is not updatable, but it is where the responsibility field is located.



    I created a query with "Asset ID" as the connecting fields.

    Since the "Tbl_Building_Asset_List" is not updateable it is not allowing me to add new records.

    How can I add new records but have this one un-updateable field on the form.



    - Or -

    Is there a way to have a message popup with the responsible party for that record.

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,399
    on your form properties data tab, try changing the recordset type to 'dynaset (inconsistent updates)'

    other alternatives on your form is to use a dlookup for the control which displays the responsible person

    or include the dlookup in your query instead

  3. #3
    ssanfu is offline Master of Nothing
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Since the "Tbl_Building_Asset_List" is not updateable it is not allowing me to add new records.
    What table are you trying to add records to? I'm guessing you are trying to add records to "Tbl_WO_Log".

    From what you said, your two tables are:

    "Tbl_Building_Asset_List" is a list of buildings and/or floors
    "Tbl_WO_Log" is a list of work orders for different building assets.

    "Tbl_Building_Asset_List" has a primary key (PK) of "AssetID_PK"
    "Tbl_WO_Log" has a foreign key (FK) of "AssetID_FK"


    I would try a main form with a record source of a query based on "Tbl_Building_Asset_List" and a sub form with a record source of a query based on "Tbl_WO_Log".
    The Master/Child linking fields would be "AssetID_PK" and "AssetID_FK".



    Maybe you would post your dB?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 06-29-2020, 12:10 AM
  2. Replies: 2
    Last Post: 11-03-2017, 11:20 PM
  3. Replies: 4
    Last Post: 02-03-2016, 09:23 PM
  4. Replies: 1
    Last Post: 08-02-2012, 02:11 PM
  5. Replies: 5
    Last Post: 06-29-2010, 01:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums