这是我的场景（MS Access 2007）：
在Form1上，我有一个记录（订单）列表。Form1有一个启动Form2的按钮。
Form2用于创建新订单。Form2上的“保存”按钮使用VBA保存记录，关闭表单并重新查询Form1：
DoCmd.RunCommand acCmdSaveRecord
DoCmd.RunCommand acCmdCloseWindow
Forms!Orders.Requery
我想做的下一步是在Form1上自动选择新记录。我猜这是用＜code＞DoCmd.FindRecord＜/code＞完成的吗？我想不通--我们非常感谢您的帮助。
Thanks, Stewart
答案将取决于应用程序是具有单个用户还是具有多个用户。在多用户场景中，简单地获得最近添加的订单不一定会返回您刚刚输入的订单。但如果只有你，获得最近增加的价值就能做到这一点。
如果使用的是自动递增键，则可以找到具有max（orderid）的行；或者如果您的订单带有时间戳，则查找具有最大值（orderDateTime）的行；或者简单地让Orderslist表单的数据源按照其中一个值进行排序，降序排列，然后重新定位到Requery之后的第一条记录。
I am copying a record from one table to another in Access 2007. I iterate through each field in the current record and copy that value to the new table. It works fine until I get to my lookup column ...
In C#, I know that I can overload the constructor for a class by specifying it in the body of the class: public class MyClass() { public MyClass(String s) { ... } } This overrides the default ...
I have an Access app where I use search functionality. I have a TextBox and a Search Button on the form, and it does a wildcard search of whatever the user enters in the TextBox, and displays the ...
i have two access tables tableA num count 1 7 2 8 3 9 4 9 5 13 6 6 tableB num count 0 1 1 14 2 12 3 5 4 5 5 11 6 5 how can i create an access query that ...
I want to show a dialog where the user can pick a file, click OK, and then the path to the file will be saved in the database. I have just one problem, I can t figure out how tho show the dialog ...
On a continouos form in ms-access, I have a record source similar to select col_1, col_2 & " " & col_3 as col_expr from tblFoo and then I have bound col_expr to a text box on that form....
I have to deal with a few macros (not VBA) in an inherited Access application. In order to document them, I would like to print or list the actions in those macros, but I am very dissatisfied by ...
I have 4 tables, from which i select data with help of joins in select query...I want a serial no.(row number) per record as they are fetched. first fetched record should be 1, next 2 and so on... In ...