Access 2016 Web App for Sharepoint update field based on first field data

Posted on 2016-09-12
Last Modified: 2016-09-20
Trying to figure out how to make a field populate based on another field which is a lookup field.  

So I have a "part loaner" that looks up "parts list".  Parts lists has a "Coalesce([Device]+" "+[Make],[Model Number])" Field, and I want the Parts loaner List to populate the "Coalesce([Device]+" "+[Make],[Model Number])" when the user enters in the parts lists ID part ID.
Question by:Knightsman
  • 4
  • 2
LVL 14

Assisted Solution

SneekCo earned 250 total points
ID: 41795907
This may be something that a SharePoint designer workflow could help out with.

Good luck...

Author Comment

ID: 41795960
Seems its not available when creating an access app.  its very restricted.  Although I guess I could make a desktop version and use it and possibly copy it over, not sure that will work, but its a good idea.
LVL 34

Assisted Solution

PatHartman earned 250 total points
ID: 41796520
Why would you want to copy the data from one table to another?  That just duplicates the data.  You could always get the current value by using a query that joins the two lists.
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline


Author Comment

ID: 41798574
I have an inventory database, and with that, a Part Loaner Tracker the user will enter the "item number" based on the inventory number on the piece, and I want it to populate the description of the piece so they can verify its the right part.  It also saves me from having to go to the other list, to figure out what it is they have loaned out.

Accepted Solution

Knightsman earned 0 total points
ID: 41798645
I realize now, that I can set the field from the main inventory to show the corresponding cell under the datasheet.  It wont help the individual but takes care of my need to know what the piece is.

Author Closing Comment

ID: 41806210
Was able to figure out a better approach to unanswered problem.
LVL 14

Expert Comment

ID: 41806464

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now