Changing Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table called input data which stores all the database info. the main
data entry page which is a form is called open page. The open page form has 4
fields to enter last names. I created a second form called additional names
to enter 10 more name fileds, because the first form was getting to
cluttered. The data that is entered on the additonal names form is also
stored in the data input table. I created a command button to open the
additional names form. The command button opens the macro called open new
form. If I am on a specific record say for example record number 10 it always
opens the new form on record 1.

MACRO: open new form

Action1: Open Form

Form Name: open new form
View: Form
Filter Name:
Where Condition:
Data Mode:
Window Mode:

Action2: Maximize

Action3: Close
Object Type: Form
Object Name: open page
Save: Yes

How do I make the macro open the additional names form showing the same
record I was modifying in the first form, example go from record 10 to record
10, instead of always going from record 10 back to record 1.
 
The second form is not used very often due to normal entires having less than
4 name entries. Just want the second form availbe to enter more data when
needed. Furhtermore, there is lots of other data entered on the first page
and the users who utilize this databse have very little computer skils, so
the data entry and navigation have to be as simple as possible. Thanks.
 
Thanks,
I was mistaken on what you meant. I looked up TAB Controls and I think that
would fit my needs much better. Thanks again
 
Back
Top