Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!



Movinf Access From Feild to Another Form Feild

By purvikpa ·
i have problem with moving one form field to another form field. my main form as frmDonations which store Employeeinformation with Donation INformation,and Form has one command button called Last Year , i generate one button click event which open another form called Last Year, which fetch (matched EmplyeeID with frmDonation EmployeeID) last year donation detail, but its not work it fetch whole last year donation detail from Last Year Table, i want to get only those record which have to match employeeid from frmDonations main form.

I need your help .

Thanks for Replying, i am waiting your reply.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Did you create a query?

by Tink! In reply to Movinf Access From Feild ...

You'll need to create a query that searches Last Year Table (or Form) based on Employee ID.

Then when you have your button click event open Last Year Form, have to use the new Query as it's LinkCriteria.

Collapse -

How i CAn create a quary which searches Form Based ID?

by purvikpa In reply to Did you create a query?

I did it in my database query, on based on last year table.

Collapse -

Read the help on Queries

by Tink! In reply to Movinf Access From Feild ...

Unfortunately I don't have the extra time to walk you through the complete process.

But one way to do it is to use the Query wizard, base it off of the Last Year Table (so it pulls info from there)

Then in the design area of the Query, put in the Criteria of the Employee ID field, put a formula to equal the Employee ID field in the FmDonations.

If you read the Microsoft Access help, it should assist you in this. If I get some extra time I'll try to come back and add more details.

Related Discussions

Related Forums