Forms Question

[Swift_74d]

I currently have two tables, one for accruals that holds year, amount and company fields (there will never be more than one entry per company per year) and one for adjustments that holds year, month, amount, company, and notes (there will never be more than one entery per year per month per company).

Is there a way to have a form that will take an entered company, year, and quarter and list the corrisponding adjustments and accrual for review and editing?

I currently have it set up as two forms. The first one allows you to choose the company, year, and quarter and the second uses the information from the first to DLookup the information. This allows review but not editing.

 

[Joe4]

Take a look at creating Subforms in Access' built-in help files. This should allow you to do what you want without having to do anything like using DLOOKUPs (the Subform is linked to the appropriate records in the Main Form).

 

[Swift_74d]

Thanks so much, sometimes finding what term to look for is harder than finding the answer.

 

[Joe4]

I know what you mean!
Glad to help.

 

[Montez659]

Swift - I agree wholeheartedly with that last statement! There have been numerous times that I have posted a problem on this board only to have the actual typing out of the question trigger in my mind a different term to search for, and then I find the answer within minutes!

Ah, such is life!