Database Deployment

[diggadave]

Hi

I am working on a database, which I will need to deploy in a number of offices.

Each record entered into the table will need to include the office ref no.

What I would like, access to display a form when first used to select the office ref no, and for access to remember it and enter it into the table automatically, each time a record is entered.

Anyone any ideas.....much appreiated.

Best Wishes

Digga

 

[SQLBI]

Digga,

I have used something similar by creating a public variable.

In a new module, within the Declarations section create a new variable and assign it a datatype according to the table it is to be posted into.

EG:

Public Office As Integer

When the user logs on and selects their office, assign the variable with the department number.

EG:

Office = txtUserOffice

Then when a new record is created, assign the control to store the Office ref the value of your Office variable.

EG:

Me.txtOffice = Office

This is a little general as i've no idea what controls you're using but you should hopefully get the idea.

Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk