Sign up for Office 365
Learn more about Office 365
im trying to macro after insert copy a record from table A to table B if a yes/no box is true and if the field Department = sales (lookup field, typed in not connected to another table, id prefer it to be though)
i get the error below and nothing copies to the new table, just a blank record
i'd appreciate any help i can get on this, im having alot of trouble adjusting to this access web
thank you in advance
Hi Jas00007,
This is Jonis from Microsoft Online SharePoint Support.
When you publish an Access database to SharePoint Online for Office 365, your tables become lists. When working with “Access web” the “Lookup field” (Lookup column?) you mentioned is one option to move data between lists when conditions are met. Other options to effectively exploit, manage and manipulate your data are to create list relationships, unique and lookup columns, relationship behaviors, and primary/secondary lookup columns. These items allow you to extract data from lists while preserving the original information in the list. The following link details these solutions, to review the article click here.
Depending on what you are looking to accomplish the following information provides optional methods to resolve your question. One of the great abilities of SharePoint Online is to store your data in a central location and allow you to create customized views to the information.
The following article details managing lists and covers limitations and additional methods to filter and view your data, to review that article click here.
Please reply to this post with your results as I will continue to monitor this thread for a couple of days and will reply to any additional posts or questions.
Jonis Estrem
Microsoft Office 365 SharePoint Support