以表格形式显示所有记录 [英] show all record in form

问题描述

大家好，

我的表格是FrmLap但只显示一条记录，如果我想看到所有记录我应该做什么？


我有主要形式FrmMain因为存在子表格SubLap。在数据表视图中，我可以看到所有记录

，当用户点击任何记录上的记录选择器时，我只能打开FrmLap中的特定记录。形式，但我想看到所有记录和什么时候FrmLap打开它应该显示该记录。


假设在我的数据表中有10条记录，如果我点击记录号5，我希望该表格应该打开所有10条记录但它应该显示5号记录，如果我点击下一条记录，它也应该向我显示6条记录。


我想只看到FrmLap中的记录通过查询以子表单SubLap查找。


这里是我的代码..

展开 | 选择 | Wrap | 行号

解决方案

这个看起来非常类似于你最近开始的另一个主题。虽然我们允许这个问题有点不同。


查看示例过滤表单，了解如何管理它。

hi NeoPa，

I知道但是这里只有一个问题我看不到所有记录，但我只能看到一条记录

所以你能告诉我我应该怎么做才能看到所有记录

hi guys,
I have form "FrmLap" but that showing just only one record if i want to see all record what i should do?

i have main form "FrmMain" in that there is subform "SubLap" that is in datasheet view where i can see all record
and when user click in record selector on any record i can open just that specific record in "FrmLap" form but i want to see all record and when "FrmLap" open it should display that record.


suppose in my datasheet there 10 record if i click on record number 5 , i want that form should open with all 10 record but it should display record number 5 and if i click on next record it should also show me record 6 like that.

And i want to see only that record in "FrmLap "which i find by query in sub form "SubLap".

here is my code..

Expand|Select|Wrap|Line Numbers

解决方案

This seems very similar to another recent thread you''ve started. As the question is a little different though we''ll allow it.

Check out Example Filtering on a Form for how to manage this.

hi NeoPa,
I know that but here is just one problem I can not see all the record , but i can see just one record

so can you tell me waht i should do to see all the records

这篇关于以表格形式显示所有记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！