Allowing only one selection in YES/NO data field

[kapil0712]

Hello,
I have a table with two columns. One is "Name" (Text data field) and other is "Flag" (YES/NO data field).
I have created a form where I have pulled in the whole table. So it looks somewhat like this:
Name Flag
John Checked
Tom Unchecked
Bom Unchecked View Report (command button to view selected name)
Sam Unchecked
Dom Checked


Now my problem is, I just need to allow the user to select only one name at a time when he hits the View Report button.Or else it should give an error that multiple entries have been selected.


I have surfed the net for a solution. I found one where they suggest to use a record button instead of YES/NO. But since my form is based on a table itself, I am not able to create a field with that data type.
What should I do? I am worst at coding. Kindly suggest a way out.
Any help is appreciated.
Thanks
Kapil

[RuralGuy]

Is your form in Continuous Form mode?

[kapil0712]

I dont know what you mean by Continuous form? In short, I have opened the table in form mode. So any change I made in form will actually mean that I am updating the table. The only reason I am using a form is that, I wanted to add the custom button (View Report)
Thanks
Kapil

[RuralGuy]

Can you see more than one record at a time on your form? What section of the form has the Report command button?

[kapil0712]

This is what my form looks like. Again, it is nothing but my table with an additional command button

[RuralGuy]

I'm not sure how you achieved that form but I believe you will find only the highlighted record on the left is the Current Record so picking up information from that single record is a snap.

[kapil0712]

I created a blank access form in access 2007. Pulled the table and placed it in the form. It did its trick...
I am not getting what you are saying. May be I am not an expert at access.
But I am stuck at not allowing multiple checks before I am ready to view my report.
Let me be very clear:

My report is based on each name, lets say. So when I am checking a name, lets say "Sam", then the report will pull all the data for "Sam".
However, once Sam is selected, I don't want the user to select one more name. Lets say, he does select one more name (since I have YES/NO data type, it allows multiple selection, but when he goes to print the report, it should give an error saying that, You have selected more than one name.

Thanks
Kapil

[RuralGuy]

So the check box is simply to specify a single record for a report? If so, you don't need a check box. What does the code (macro) behind the command button look like?

[kapil0712]

Yes. Check box is to specify single location. Then how do you suggest to select one record?
The command button is simply what access under controls, (Using Command button wizard, Under report operations, View Report)
Please give a solution.

[RuralGuy]

It would be a lot easier if you would just post your db and I'll fix it for you and post it back.

[kapil0712]

My database. Sorry cant update it with data. Its confidential
Thanks

[RuralGuy]

There is no code or macro behind the Preview Report button but it shows the left side of your form as a SubForm of a table in Datasheet mode. I created a separate SubForm so I could reference it from the MainForm. Give this a try.

[kapil0712]

Thanks...Is there any other solution...with a check uncheck or radio buttons?

[RuralGuy]

Is the method I used not acceptable?