Form Design Help

[melodyF]

I'm working with the following table data..

tblEmployees tblACDStats
Bnumber Bnumber
Lname Incoming
Fname Missed
Dept WaitTime
TalkTime
My one to many relationship is the Bnumber field. I can have many Bnumbers in the tblACDStats. We want to setup a form that our clerk can go in and key the ACDStats each day for each Bnumber. What I would like to do, if possible, is set-up a form that already has the Bnumber listed and just have her key in the Stats instead of having to select each uniqe Bnumber from a dropdown and then key in and submit. It would be a lot more efficient to have everything listed and just fill in fields and submit all at once. Ex:
Bnumber Incoming Missed Waitime
B80206 ---- ---- ----
B80215 ---- ---- ----
B80022
B80125

Any suggestions to get me started..

Thanks

 

[Jack Cowley]

Use an Append query to add the appropriate Bnumbers to the table. Then use a query to show the Bnumbers where the fields to be filled in are null. Base a form on the query.

 

[melodyF]

Jack, I believe your suggestions will work. A couple of questions.

How do I make sure the users only append the BNumbers once a day. Also, how do I turn off the message box stating that I'm about to Append blank amount of records..

Thanks again..

 

[Jack Cowley]

Add a table to the db with just one field and make it a date field. When you run your append query update the date in the table to todays date.

In your code that runs the append and update queies use DLookup first to get the date in the table and if it is todays date then popup up a message box saying the append query has already been run and exit the routine.

To stop the warning messages use code like this:

DoCmd.SetWarnings False
--you code here--
DoCmd.SetWarnings True

Good luck!