Option Button

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Hello:

I have a button control on the detail segment of my
form. This is a subform to the main form.

The relationship between both is booking no. There are
normally 3 subrecords for every main record. one of the
fields in the subform is a confirmation button where when
one of the subitems is selected the record is basically
closed. The following is an example:

Booking 1
Customer: Wallman

subform

Booking dest cost option button
1 lax 1000
1 jfk 1300 .
1 san 1500

At this point since an option button has been selected, I
want to run a filter on my form to only see records that
have not had an option selected.

I am just about done with this project but need to add
this one piece and I am stuck.

Please help.

Thanks.

Pat
 
I think you are wanting to filter the main form so that it only contains
those records that have a subform record that has your Yes/No option button
field showing No (not selected).

If that's the idea, see:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

The article explains how to reassign the RecordSource of the main form to an
INNER JOIN statement, so it only contains the records that have a match in
the subform.
 
Back
Top