Toggle buttons

[barra47]

I have a form with 2 subforms
MainFrm
Subfrm1 used as a tool bar with several buttons
subfrm2 datasheet

In subfrm1 I have a Toggle button, when i click it, I want subfrm2 to display all records and with another Toggle button
I want to display only records where datefield has no date .

Hope that makes sense

Thanks in advance

 

[dhookom]

Add code to the after update event of the Option Group containing the toggle buttons that change the record source of the subfrm2.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

How are ya barra47 . . .

One button updates the [blue]RecordSource[/blue] of subfrm2 with an SQL statement that returns all records. The other button updates with the same SQL only this time its appended with a WHERE clause comparing the datefield to NUll.

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]