subform problem (filtering, update main form)

[hoschi]

Hi there

I got a Form with a subform. In the Form there are all Information of the record. The subform is like a listing of the todays added records with only four fields of information.

1. How can I filter the subform OnOpen to show only todays records?

2. I want to add to the subform a button with following action:
In the subform I'm on the 2. record but the Form is on the 1. record. I click on the button and the form shows me all the informaiton of the 2. record.

The subform should be like a lookup of the todays records and when I want to change or add something I use the Main Form!

Any Ideas?

thanx

hoschi

 

[Rich]

Base the subform on a query and set the criteria for the date field to =Date()

 

[hoschi]

thank you very much

...that works great!!! thank you very very much

But I still got the other problem.

I tried something and came to this: when I change the record from the main form, the subform updates itself automatically. I did this with Link Child Field and Link Master Field of the record number in the subform.

But I want it to other way, when I change the record in the subform, I want the mainform to update itself!!!


thanx
hoschi