need form/ subform help again and again

[phineas629]

Hi all,



I've attached a copy of my database with example data. I've spent the last 2 months trying to make my database with minimal progress (When you open my DB, you will see how little I’ve done). It's not for lack of trying. I've read books and used the forum. Not knowing vba has been a great hindrance. It has irked me that the wizard has done all the work and I know nothing that’s really going on behind the scenes.



Until I’ve learned vba (I'm a slow learner), I would love some advice to make my form/subform more functional. It’s main use will be for data input by my coworkers. Claims are filed every 2 weeks with up to 14 entries for each day. Most of these entries will be repetitive.


Thanks in advance (and to all who've helped so far)



p.s. if you see some normalization issues that may occur then please lemm know

[June7]

I think you have a good start.

You are displaying primary and foreign key fields. Probably not necessary. Usually autonumber primary keys are invisible to users.

The embedded macros will probably perform satisfactorily, but if you want to do more advanced processes will be good idea to learn VBA. It is not a difficult language. Just as important is understanding general programming concepts.

Here is a start http://office.microsoft.com/en-us/access-help/introduction-to-access-programming-HA010341717.aspx#BMconvertmacrostovba