Need help on Data entry form. Urgent!!!!

[jayanth1808]

Hi, I am new to access... I just want to prepare a simple data entry form. I have table "Activity", where all team names, function names, and cycle times are stored.

And I have another table "Volumes" with columns Date,Team,Function,Volumes.

I need a form with one combo box with distinct team names and if we select team name, it shud show all the functions for that team from Activity table. we need to update volumes for that. after entering all data, if we click "upload to volumes button", all those records shud be saved in volumes table with current date.


Please help me out.. its really urgent.

Thanks in advance

 

[jayanth1808]

Access Experts... please help me. its very urgent.

 

[Poppa Smurf]

What version of Access are you using? The attached is in 2002-2003 format.

Open the form frm_input. The boxes on the Right Hand Side displays the current data in the record. For new record it will display the data uploaded from the input screen.

 

[jonesey]

Hi
another variation attached, in case you need to add more fields to any of your tables in future without duplicating data. Vulume data entered via the form (which has an underlying query) is automatically stored in the volumes table. you can add calculated fields to the query or the form later - or use reports for the same. i used your original file as a starting point and it has a reference to a previously deleted form in the startup options, which I have only just noticed after uploading, so will show an error on startup until startup options are modified.

 

[jayanth1808]

Hi Poppa Smurf, jonesey..

Thanks so much for your support....

ur database gave me some inputs.. so i have prepared a database according to my requirement... I am attaching that.. u can have a look at that also..


Thanks alot guys....