Creating a Form with Multiple Prepopulated Text Boxes

[fortwrestler]

And.... I should probably just change the title of this post.

So,
How would I go about only showing the Append query for the given filler/date.

I'm trying to make this user friendly, and if I change fillers, all values in the table are shown rather than just the fields just for that filler for that day.



Also,
Is there any way to change the error message I get "Microsoft Access can't append all the records in the append query" to a more friendly "This data has already been entered for the day".

Thanks for all the help...again

 

[pbaldy]

What is the subform based on now? The SQL I showed earlier would only show the desired filler/date.

I would probably test for the filler/date combination before running the query, and provide my message box then. You can test with a DCount() or recordset, whichever you're comfortable with.