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