Query is affecting other forms

[planetdrouin]

I am relatively new to Access, so this may be a moronic question, but the help would be greatly appreciated.

I have a form (call it form A) that shows all transactions by client ID with the ability to dig down and see details (on another form, form B, which is the original entry form). I then added another form (form C) that shows all the transactions from the previous 30 days. I accomplish this using a query and setting a criteria of ">Date()-30" in the date field.

Since adding form C, my ability to dig down and see details from form A has been compromised. Form A still works fine, but when I dig down to see details of any transaction older than 30 days, form B is blank (which uses the original table as its source). What seems odd to me is that only form C uses the query that restricts the date field.

Should I be using a different method to create form C or is there some language I need to use to negate the effect of my date limiting query?

Thanks

Lawrence

 

[dmlatham]

Lawerence,

Which form is feeding C? A or B?

Are all of these tables using the same record source?

Deb

 

[planetdrouin]

Deb,

Thanks for the input. Looks like I have made a rather simple blunder as the record source for form B and C are the same. This should not be the case, which is creating my problem.

Thanks