SnapShot.png

<div>
What does selecting a record mean?<br />
<br />
This requirement might actually be implemented more easily by storing the ID of the selected child record in the parent record. &nbsp;That way, the selection of a new child record automatically overwrites the old ID. &nbsp;Of course, this would change your queries but probably not dramatically. &nbsp;I don't see any reason that this violates first normal form and it sure makes the requirement easier to implement.<br />
<br />
If you keep the flag on the child record, you would need to intercept the update and first remove the flag from any existing records before allowing it to be saved to the current record.
</div>


<div>
Dear <b>Rayan</b>,,,<br />
It is not &quot;<i><u>listbox or combo box</u></i>&quot;.<br />
<br />
My record set is a Data Set in a Sub Form which in turn is based on a query. <br />
I need the Check-Box, (when = Yes) &nbsp;for further processing after making this selection. <br />
So I am concerned that the user can make one selection only.<br />
<br />
I hope this clarifies the issue better.<br />
<br />
Dear <b>Pat</b>,,,<br />
<br />
Sure I am clearing these check-boxes before leaving the form.<br />
I got the inspiration from you to stick an update query &quot;After The Update Event&quot; to clear all other selections except the current one.<br />
<br />
I thought there could be an easier way.<br />
<br />
Anyway I will try and let you know.<br />
<br />
Thanks for both of you.
</div>


<div>
<blockquote>
I thought there could be an easier way.
</blockquote>
Easier than what?<br />
Running an update query to clear existing selections<br />
or<br />
Storing the ID of the selected record in the parent record?
</div>


<div>
Dear Ryan,<br />
<br />
My Combo box is attached herewith. It is based on a query from a table.<br />
Is it possible to convert it to be a list box?<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/04_w18/1159464/Capture.PNG" target="_blank" title="Combo Box (25 KB)"><img alt="Combo Box" class="file-block lazyload" style="max-width: 465px;" data-src="https://filedb.experts-exchange.com/incoming/2017/04_w18/1159464/Capture.PNG" /></a>
</div>


Capture.PNG

<div>
Put the form into design view. &nbsp;Click on the combo to select it. &nbsp;Right click and choose the option to convert to a listbox.
</div>


<div>
Pat is right on that.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/05_w18/1159706/SnapShot.png" target="_blank" title="SnapShot.png (24 KB)"><img alt="SnapShot.png" class="file-block lazyload" style="max-width: 522px;" data-src="https://filedb.experts-exchange.com/incoming/2017/05_w18/1159706/SnapShot.png" /></a>
</div>


<div>
It shame of me. &nbsp; lol. Where do I find the &quot;&nbsp;Build &nbsp;Event... in order to convert it to List Box.<br />
<br />
&quot;<a href="https://filedb.experts-exchange.com/incoming/2017/05_w18/1160650/Capture-Cmbox2.PNG" target="_blank" title="Cmbox2 (18 KB)"><img alt="Cmbox2" class="file-block lazyload" style="max-width: 458px;" data-src="https://filedb.experts-exchange.com/incoming/2017/05_w18/1160650/Capture-Cmbox2.PNG" /></a> <br />
<br />
Sorry if it is too obvious.
</div>


Capture-Cmbox2.PNG

<div>
Sorry I thought that I closed this.<br />
Thanks for the help. Problem is solved.
</div>


<div>
<div class="content wysiwyg-content">
Hi All,,,<br />
<br />
How to let a Yes/No switch select a One record from the displayed record set?<br />
<br />
Like say a list of countries, I want to allow selecting one country only. i.e. If the user goes to other record, the first selection to be deselected.<br />
<br />
Thanks
</div>
</div>


Hi All,,,

How to let a Yes/No switch select a One record from the displayed record set?

Like say a list of countries, I want to allow selecting one country only. i.e. If the user goes to other record, the first selection to be deselected.

Thanks

How to let a Yes/No switch select a One record from the displayed record set?

Switch

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.