Need Help with query to filter the form and copy the value..

[abdnal0519]

Hi everyone,

i'm rookie with access. I need help with a query. I have three fields on my form, Status, Value1 and Value2. When i change the status from say A to B i need value from Value1 field to be copied to Value2.

any suggestions..

 

[plog]

When i change the status from say A to B i need value from Value1 field to be copied to Value2.

That's not how databases are to work. Data doesn't move around from field to field or table to table. You use logic instead.

Most likely this will be done in a query, or possibly in the form via a Dlookup on an unbound control. But because you've not really explained your system and overly genericized it, could you better explain the situation?

1. Without using any database jargon or referencing the database at all--explain what real-life process you are dealing with. Pretend its career day at an elementary school and just explain what you do and this particular issue.

2. Explain your tables/fields. Provide actual table and field names and a short description of how this database implements #1 above.

 

[abdnal0519]

ty for the prompt response.

This form is for Project Manager to assign resources to a specific project.
I have a Project table, Resource table and Status table listing all the Status (1. Initial, 2. Approved, 3. Closed). When the project is in status 1, PM assigns Inital estimates (Time) for a project, that sits in field Value1. When the PM moves the status from 1 to 2 the resource manager will input his estimates in Value2. When the resource manager for the first time trying to estimate the the resource time, he needs to have an idea what the initial estimate was by the PM (Value1). for that reason we want to copy value from field Value1 to Value2. We do not want to display the field Value1 on the form.

Below tables:

Project table (List all the projects with fields to assign resources to the projects and fields to enter estimates for the resources)

Resource table (all the resources who will be assigned to the projects)

Status (List all the project status)

I created a form using the above tables for the PM and RM to assign resources and time against that resources.

sorry if the explanation isnt clear...i will try my best to clear doubts you have..again..thanks for the input..