W
Wayne
I have a form linked to a master contracts table. I have setup the
form so that when the Contract_Number is selected from a combobox the
other contract fields autofill using DLookUp in the Control Source for
each textbox. Here’s an example:
=DLookUp("[Client_Name]","tblContracts","[ContractID] = " &
[Contract_Number])
This works great. The problem is when I use the Navigation button to
step to the next record I get the following message:
“The value you entered isn’t valid for this field”
I believe the error is due to the Contract_Number combobox since I am
using a query in the Row Source as follows:
SELECT tblContracts.ContractID, tblContracts.Contract_Number
FROM tblContracts
ORDER BY tblContracts.Contract_Number;
In the Contract_Number textbox I have set the following:
Column Count = 2
Column Width = 0”;1”
Bound Column = 1
I think when I use the Navigation buttons it trys to insert the
ContractID into the Contract_Number field which is a Text field. Not
sure how to fix this.
Is there a way to autofill plus be able to use the navigation buttons
to step through records?
form so that when the Contract_Number is selected from a combobox the
other contract fields autofill using DLookUp in the Control Source for
each textbox. Here’s an example:
=DLookUp("[Client_Name]","tblContracts","[ContractID] = " &
[Contract_Number])
This works great. The problem is when I use the Navigation button to
step to the next record I get the following message:
“The value you entered isn’t valid for this field”
I believe the error is due to the Contract_Number combobox since I am
using a query in the Row Source as follows:
SELECT tblContracts.ContractID, tblContracts.Contract_Number
FROM tblContracts
ORDER BY tblContracts.Contract_Number;
In the Contract_Number textbox I have set the following:
Column Count = 2
Column Width = 0”;1”
Bound Column = 1
I think when I use the Navigation buttons it trys to insert the
ContractID into the Contract_Number field which is a Text field. Not
sure how to fix this.
Is there a way to autofill plus be able to use the navigation buttons
to step through records?