访问表单打开下一个不完整记录 [英] Access Form open to next incomplete record

问题描述

您好，


我正在构建一个使用一个表和两个表单的Access数据库。


一个用户放置部分信息作为要求完成的一个表格，另一个用户打开他们的表格版本，允许他们完成通过输入他们的信息来请求。


我已将数据库拆分并将所有用户发送到前端，而我将后端保留在共享文件中。所有更新都运行正常。


我遇到的问题是，当第二个用户打开第二个表单时，表单始终打开第一个记录。我想要它做的是打开第一个在特定字段中具有null的记录（我希望它们处理的下一个请求）。如果有人可以帮我解决这个问题，那将非常感激。

Hello,

I am building an Access Database that uses one table and two forms.

One user puts part of the information into one form as a request to be completed and another user opens their version of a form that allows them to "complete" the request by putting in their information.

I have split the database and sent all users the front end while I maintained the back end within a shared file. all updates are working just fine.

The issue that I am having is that when the second user opens the second form, the form always opens to the first record. What I want it to do is open to the first record that has a null in a specific field (the next request that I want them to process). If anyone can help me figure this out, it would be really appreciated.

推荐答案

这两种形式都应该有相同的基础记录源（特别是排序顺序），但在表单2的RecordSource，你需要设置你的特定字段IsNull的标准。


Phil

Both forms should have an identical underlying recordsource (particularly the sort order), but in the RecordSource for form 2, you need to set the criteria that your specific field IsNull.

Phil

我是Access的新手，所以请轻松。

I am pretty new to Access, so please go easy.

两种表格的记录来源相同。第一个表单放入8个字段，第二个表单读取这些字段，然后放入3个字段。我希望第二个表单打开到下一个尚未填充这3个字段的记录。这就是我正在讨论的Null部分。

The record source is the same for both forms. The first form puts in 8 fields and the second reads those fields and puts in 3 more. I want the second form to open to the next record that does not already have those 3 fields filled in. That was the Null part I was talking about.

这篇关于访问表单打开下一个不完整记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！