I have a table with a Yes/No selection that has two records in it - they designate the company to select for a query I am running - I want to be able to display the selected Company ID on the form (which is from the Query of the table - where the Select field is Yes
Select COID Comapny NAme
Yes CO1 Company 1
No CO2 Company 2
Open the table with a button - select which company - using the check box - then display the company ID & Name in a field on the form - Normally will remain that same company - so it does not have to always be re-selected - just needs to change when the different comany is selected. Not sure about getting the "display" field to change when the selection changes.