Multiple forms for 1 record

[rcpbaby1]

Hi,
I have searched the FAQ's and past posts without success to the following basic problem (I say basic because I'm very new to this but would think it very basic to you guys!).

Anyway I have a table with approximately 30 fields. I have split these fields over 3 forms so that they don't look cluttered.

When I start to enter new data in Page 1 I would assume that moving to Page 2&3 the fields would be blank because of selecting 'enter new record' within Page 1. They're not, they still display the previous record.

Have I missed something here! Please forgive the naiveness of it all, I'm on a steep learning curve!

Thanks
RCP

 

[MoLaker]

Instead of multiple forms, take a look at a tab control. With a tab control, you can use the same form and put fields of the same record on different tab pages to reduce clutter.

 

[rcpbaby1]

Thanks MoLaker, but I've already developed the forms and think some code would help pass the current ID into the next form, i.e. something like the following (but am new to this):

DoCmd.openform “frm2”, acnormal,,"ID =" & me.ID

but not sure if this is correct or not

thanks
RCP