save all information under a PROJECT

[Gilberto]

Hello

I have 3 different forms where different users enter information to the same products. i.e. (First the engineer will provide the products, weight, etc, then a costing guy will enter costs, amortization, etc, finally the pricing depatment will enter commercial information, all working on the same products.) These three forms are alredy made and working (ENGINEERING, COSTING and PRICING). I created another form (PROJECTS) where when opening the database the user will select the project and be able work with that specific data.

How do i link or create the relationships so that after selecting/creating a new project all information starts being classified as from THAT project, or do i have to specify for every product (ENGINEERING FORM) the project it belongs to???

please help,
Gilberto

[Rabbit]

You will have to specify what project every product belongs to. All of it can do done invisibly using VBA code. How you do it depends on your exact circumstances.

[Gilberto]

You will have to specify what project every product belongs to. All of it can do done invisibly using VBA code. How you do it depends on your exact circumstances.

Thank you for your quick response.

How can i do this invisibly and automatically for every product ONCE i have selected on the oppening form the name of the project??? (could you give me some code please)

Also once this is done, what kind of query do i need so that once you select the project, it will take you only to those previously entered products for further modification, addition, etc.???

thank you again,
gilberto

[Rabbit]

The DoCmd.OpenForm function has a filter parameter you can use to only show records that match the criteria. And as for initializing the project name you could do it through a global variable, through the OpenArgs parameter of DoCmd.OpenForm, or even storing it in a table or form.

[Rabbit]

Resuscribing .

[Gilberto]

The DoCmd.OpenForm function has a filter parameter you can use to only show records that match the criteria. And as for initializing the project name you could do it through a global variable, through the OpenArgs parameter of DoCmd.OpenForm, or even storing it in a table or form.

Thanks again. that sounds pretty good however i have not real experience with using CODE. Actually the projects name with their information (description, client, etc.) will be stored at a table.

Could you help me with some code???
The basic idea is that every product (which are stored in the ENGINEERING table) gets classified with a project name (which are stored in the PROJECTS table) once the user select/creates the project on the initial PROJECTS form)

i hope this helps.

thanks,
gilberto

[Rabbit]

Form1
cboProject; Combobox; Text
cmdOpen; Command Button

Private Sub cmdOpen_Click()
   DoCmd.OpenForm "Form2", , , , , , Me.cboProject
End Sub
 

Form2
txtProject; Textbox; Text

Private Sub Form_Load()
   Me.txtProject.DefaultValue = Me.OpenArgs
End Sub