need help on the best way

[Chey]

I log in what we call bills
I have created a form where I log in the amounts.
In the form header I have 2 combo boxes to look up information.
THis is the part I am unsure if is right or if there is a better way.
I have a combo box that I assign a "batch number" 1-8 if I am working on
batch 1 when I choose my billing month and choose my provider number it
creates a new record and under theMonth it puts the billing month and
provider number. But then it needs to refresh with the provider information.
If this is not a good way what should I do.

I have two tables.
tblChild Care Providers
tblGrantCompletion

Child Care Providers is there persoal information ie Name, addy, phone
tblGrantCompletion is linked by ICCIS # (that is like our ID) and has
monthly information on each provider.

So when a provider turns in a bill for January a new record is inserted into
the GrantCompletion table for me to work off of.

Thanks
Cheyenne

 

[Arvin Meyer [MVP]]

Have a look at the following to see how I handle requerying the list/combo
boxes:

http://www.accessmvp.com/Arvin/Combo.zip