Adding one record over a number fo forms

[wdverner]

Hi All,
I wish to create forms to add a record to a table. The user wil be asked to fill in several fields, then click Next to progress to the next form until they have completed all the necessary fields.

i wish to break it up due to the sheer volume of fields required.

The records are unique via an AutoNumber RoomNumber, so what I want to achieve is to add ONE record by taking all the info from all 5 forms?

Is this achievable?

Many thanks

 

[lupins46]

Use a tab control on your form. Divide the fields into sensible groupings using the tab pages.