<div>
You would have to use different queries depending on whether this was a new record or an existing one but that isn't how you should be controlling the ContractNumber. &nbsp;You should lock the control except when you are on a new record and that will prevent anyone from changing it once it has been entered.<br />
<br />
In the Current event of the form:<br />
<br />
If Me.NewRecord = True Then<br />
&nbsp; &nbsp; Me.cboContractNumber.Locke<wbr />d = False<br />
Else<br />
&nbsp; &nbsp; Me.cboContractNumber. Locked = True<br />
End If<br />
<br />
This will still allow you to change the contract number until you leave the record. &nbsp;If you want to lock the combo as soon as the record is saved, then in the AfterUpdate event of the form, add:<br />
<br />
Me.cboContractNumber.Locke<wbr />d = True
</div>


<div>
Pat, I appreciate your suggestion and will lock it if is not a new record. &nbsp;But I still want to have it display whatever was selected when the record was created.<br />
<br />
John, your suggestion may work but I need to have it as VBA code. &nbsp;I don't know how to convert it.
</div>


<div>
<div class="content wysiwyg-content">
On a form I have a single select listbox. &nbsp;The SQL behind the listbox is:<br />
<br />
SELECT tblLoadsHeader.LoadRecordI<wbr />D, tblLoadsHeader.ContractNum<wbr />ber<br />
FROM tblLoadsHeader<br />
ORDER BY tblLoadsHeader.[ContractNu<wbr />mber];<br />
<br />
Which display all ContractNumbers in tblLoadsHeader.<br />
<br />
This is fine for a new record. &nbsp;But If I'm viewing an existing record I only want to see the ContractNumber in the listbox that was selected when the record was created. &nbsp;Note: &nbsp;The contractnumber IS being stored in the table that is the record source for the form.<br />
<br />
How can I make the listbox only show that record?
</div>
</div>


On a form I have a single select listbox.  The SQL behind the listbox is:

SELECT tblLoadsHeader.LoadRecordID, tblLoadsHeader.ContractNumber
FROM tblLoadsHeader
ORDER BY tblLoadsHeader.[ContractNumber];

Which display all ContractNumbers in tblLoadsHeader.

This is fine for a new record.  But If I'm viewing an existing record I only want to see the ContractNumber in the listbox that was selected when the record was created.  Note:  The contractnumber IS being stored in the table that is the record source for the form.

How can I make the listbox only show that record?

How limit list selections if record is not a new record

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.