Filter Form based on subform field??

[TechnoMom]

I have form for Group Reservations and one for Birthday reservations. Both are tab control forms with several subforms and draw data from all the same tables. However, when I open the Group form I would like to filter out the birthday data and vice versa.

Both forms are based on [Reservation Table] with their subform child/master link based on the [GroupID]. There is a field on the subform called [GroupType]. I would to based the filter on this field. If I use a query for the form record source, then I cannot add new records.....I think.

Someone point me in the right direction.

 

[PHV]

Have you tried to bind your form to a query instead of directly the table ?
In my opinion, it's the best approach.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TechnoMom]

PH - that was my first approach. However, unless I'm doing something wrong, I could not add new records. Is there some property to change to allow this to work?

Thanks

 

[PHV]

Provided the query is updatable, you may consider it exactly the same as a table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bigmedia]

Hi

I have the same problem with a query
I can't update or add new records to it

how do I make this updatable ??? any tip ?
Thx
Tom