Carrying data throughout Navigation Forms

[drrob1983]

Dear forum,

may I first of all confess my lack of experience and knowledge. secondly, may i say that I am keen and quick to learn.

I have three forms which I have compiled into a navigation form. Each record in each form is linked by a uniquely identifying 'UNIT NUMBER'. The idea is that each form has been derived from a table.

One table collects customer details (first name, surname, date of birth, etc.) with each record given a unique 'UNIT NUMBER'. This is then linked by a one-to-one relationship to a second table which collects preferences about the customer (again, identified by the 'UNIT NUMBER'). This is then linked by a one-to-many relationship to the third table which collects information about previous orders.

In the navigation form format, the data from each of the tables is presented in a separate form under one of three horizontal tabs. My question is how do I select the relevant customer record in the first form, and have the same customer data carry through into each of the subsequent forms without re-entering the 'UNIT NUMBER' factor?

your help would be greatly appreciated.

[NTC]

basically there are 2 approaches I see used:

a. if there is a form that is always open (generally it is the screen that first opens with the app and is the starting point) - then this is a convenient location to put unbound text boxes that hold a value. This value then is referenced to in a form's opening arguments. these textboxes are made not visible typically.

b. if the user interface is to go from form to form - and there is no form always open....then you must capture the the cross referencing value and include it in the opening arguments of the new form before closing the existing form....which is easy to do.

in both cases you need familiarize yourself with the form opening arguments - you can find that generic example in VBA Help and of course in an Access textbook.

[drrob1983]

Hi NTC,

I assume you mean the VBA help in microsoft. or do you have a different resource in mind? it may help to know that my navigation form takes the form of your second option. I wouldn't know how to create something like the first option, although that may prove easier. i must say, i'm not entirely 'au fait' with VBA and so would like to keep that to a minimum, unless you can point me in the direction of something particularly easy to grasp as a primer.

kindest regards.