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?
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.