Query in a Form

[Foad]

I am novice at this and I am trying to make a form using 2 tables and a query. And I want to use the form as a Data Entry form. When I use the 2 tables to make the form everything looks good. When I try to put the field from the query it will not create a Data Entry form

 

[MStef]

Why do you want to add a query ?? If you want the value from this query in your form, do it via DLookup function.

 

[WIS]

I am novice at this and I am trying to make a form using 2 tables and a query. And I want to use the form as a Data Entry form. When I use the 2 tables to make the form everything looks good. When I try to put the field from the query it will not create a Data Entry form

When you say that you are using 2 tbls and 1 qry, is the qry derived from the 2 tbls being joined on a common fld?

 

[rainman89]

Create one query that has all of the information from both tables and other query. If they are not linked correctly you will not be able to use it as data entry

 

[Foad]

thanks guys: I tried to create a single query with all the info I need from the table and the query but it did not happen.
What I have is a table with employee info. and other with Employee leave request table. From these 2 tables I find out using a query what the employees vacation entitlement is. Now I am trying to create a from that employees can request for vacation. When they input their id number their name pops up. And they can request for leave. Up to this point everything works fine. But once I want to add also the vacation entitlement and hoping that would also pop up it does not happen.
Have I confused everyone

 

[Foad]

thanks guys: I tried making one query for the 2 tables and a query to create a form for data entry and it did not work.
What I have is a table that has employee info and another table that has employees request for leave. From these 2 tables I have created a query that would find out what is the vacation entitlement of the employee is. Now I am trying to create a data entry form for employees to request for leave. When I use the 2 tables that I have to make a form it works fine. And once I put the id number the name and info of the employee comes up. But once i try to put the vacation entitlement in the form it does not act like a data entry form even though i set it as such. What I am hoping it will do is also show (pop up) the vacation entitlement at the time the employee is asking for leave.

have I totally confused every one

 

[rainman89]

Can you post up a sample?

 

[Foad]

Here is the program

 

[rainman89]

You have it split so I cannot see the structure of your employees table but is that where you are trying to insert the entitlement amount?

 

[Foad]

My employee table is linked to another dbase table. But where i want to put my entitlement (from my query) is in my employee request form

Thanks

 

[rainman89]

But is that value being stored in the employee table?

I wouldn't try to edit the employee information from the timeoff request form. I would do it seperate, unless you are manually changing it once its approved..

Then What I think you may need is a mainform that Is linked to the employee and a subform that has to deal with the employees time request. Then you can link the 2 on the employee ID..

 

[Foad]

the value is not being stored anywhere it is running in the "vacation entitled" Query and that is where I want to extract from and put it on my form

The employee information is not being changed with the time off request form. That one has its own form in another data base. This table basically has the employee basic information name, age, contact etc. I use this one just to get the name and department info from it.

The employee Id on the 2 tables and on the Vacation entitled query are already linked to each other.

Thanks for all your help

 

[rainman89]

the value is not being stored anywhere it is running in the "vacation entitled" Query and that is where I want to extract from and put it on my form

The employee information is not being changed with the time off request form. That one has its own form in another data base. This table basically has the employee basic information name, age, contact etc. I use this one just to get the name and department info from it.

The employee Id on the 2 tables and on the Vacation entitled query are already linked to each other.

Thanks for all your help

Can you not link the information in the vacation entitled query to the employee table and have all the information in the one query then base the form off of that query?