Question Locked

Ms Access 2003

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello there,
I'm having problems with my 2003 ms access database. I'm having a form that link to more than one form. When I click the open form button on the main form. I want the link form to open and works like a subform. eg the link field should be filled already for every record I entered on the link form.

Can anyone help please

3 replies

by john.a.wills

If you look at the VBA for your OpenForm - look at the OnClick property of the button - you will find the possibility of constructing a criterion (called a criteria because the people who invented VBA got mixed up). Alter the VBA to restrict the opening form to showing the rows referenced in the calling form.

This discussion is closed to new replies.