表单不显示现有数据 [英] Form Doesn't Display Existing Data

问题描述

我正在尝试为大型数据库创建数据输入表单。有一个父表单，其中6个表单与一对一关系链接（由于大量字段）和几个表与一对多链接。全部都有自动更新/删除选中。日期条目表单使用选项卡控件（跨11个选项卡）和某些表的子表单。我有两个问题...


首先，如果我输入表格中新记录的部分数据（例如填写标签1-3）然后关闭它，数据出现在表中，但是当我重新打开表单时，记录不会出现，因此无法完成数据输入。


其次，**编辑如何自动导航到下一个标签 **


我是一个相当新的访问并且不熟悉它背后的所有代码等，所以我很感激任何建议！


谢谢

Hi,

I am trying to create a data entry form for a large database. There is a parent form with 6 forms linked with a one-to-one relationship (due to a large number of fields) and several tables linked with a one-to-many. All have auto update/delete checked. The date entry form uses tab control (across 11 tabs) and subforms for some of the tables. I have two problems...

Firstly, if I enter part of the data for a new record in the form (eg fill in tabs 1-3) and then close it, the data appears in the tables, but when I re-open the form the record does not appear, so it is impossible to complete the data entry.

Secondly, ** Edit How do I Navigate to Next Tab Automatically **

I am fairly new to access and not familiar with all the code etc behind it, so I would be grateful for any advice!

Thanks

推荐答案

这听起来很像你有表单的数据输入属性设置。这确保不会看到现有数据。只能输入新记录。请在上下文相关帮助中查看。


NB。请记住每个线程只有一个问题。

This sounds very much like you have the Data Entry property set for the form. This ensures no existing data can be seen. Only new records can be entered. Check it out in Context-Sensitive Help.

NB. Remember only one question per thread please.

感谢您的回复。表单上的数据输入属性设置为否，我可以看到之前在最后一个表单上输入的所有记录，我不得不重新设计以添加更多字段。当我打开表单时，有417个条目。如果我开始添加条目418（例如输入ID和另一个字段），数据将显示在表格中，但是当我再次打开表单时，它仍然只显示417个条目。

Thanks for the response. The Data Entry property on the form is set to ''No'', and I can see all the records displayed that were previously entered on the last form, which I have had to redesign to add more fields. When I open the form there are 417 entries. If I start to add entry 418 (e.g. enter ID and another field) the data displays in the table, but when I open the form again it still shows only 417 entries.

这是一个你自己创作的形式或你继承的东西？


什么版本的访问？


主窗体的记录源是什么？


标签1-3是主表单或子表单的一部分吗？


当你查看表中新创建的记录时，关键是填写/ id字段？

Is this a form of your own creation or something you have inherited?

What version of access?

What the recordsource of the main form?

Are tab 1-3 part of the main form or a subform?

When you look at the newly created record in the table is the key/id field filled out?

这篇关于表单不显示现有数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！