How can I open several pages on the same recordset ?

[Erik]

How can I use multiple pages on the same recordset ?
e.g. My database needs language selection on page one. This selection is a
datafield in the database (so it must be stored) and depending on the user's
selection I want to open a new page where the user can add his/her
information, displaying the language selection. After completion filling in
the second form, a new record is selected and the first page must be diplayed
again.

 

[Tom van Stiphout]

On Wed, 26 Nov 2008 16:39:01 -0800, Erik <Erik
@discussions.microsoft.com> wrote:

I don't fully understand. Why would the second page be
language-specific? If you are say supporting English and French, and
the second page is otherwise the same, then simply change the labels
on the fly in the Form_Open event:
if Forms!Form1!cboLanguage.Value = 1 then
Label1.Caption = "English text goes here"
Label2.Caption = "English text goes here"
else
Label1.Caption = "French text goes here"
Label2.Caption = "French text goes here"
end if

-Tom.
Microsoft Access MVP

 

[Erik]

Hi Tom !

Thanks for Your reply.
I'd like to invoke another page because of background pictures and layout.
I hoped openAccessDataPage was the solution but unfortunately ...
I'm selecting the language on the first page and like You say, depending on
the language another language specific page is opened with another background
etc.
But the database on which the pages are working is the same and the record
is complete if all information is filled in and the 'next' button on the
navigation toolbar is pressed.

It isn't easy to explain as well I think, though trying my best.

Grtz,
Erik