Greetings all,
Here is my scenario:
I have a DB that deals with inventory, both owned and 3rd party client inventory.
When equipment comes in from a customer, I have a form that allows the receiver to create an incoming invoice in tblIncInvoicecC.
Next, the person will enter the equipment that physically came in on that invoice. So the next form they use is one to enter all of the equipment information that gets stored in tblClientInventory.
I have a few combo boxes on this second form that allows the user to select controlled input such as the Model, Category, Status, Manufacturer, and Inbound Invoice. This Inbound Invoice combo box is set to pull up the list of previously created invoices from tblIncInvoicesC. When all of the information is entered and I attempt to save the record entry, I get the following error:
For a bit of reference, let me recap the other combo boxes:
The Model combo box looks up Model types from tblModelC and when selected, that information, along with all of the rest, is written to tblClientInventory.
The same process is applied to Status from tblStatusC, Category from tblCategoryC, and Manufacturer from tblManufacturerC. All of these combo boxes work perfectly, but for some reason the invoice combo box does not.
I have used the same methods for generating the Control Source, Row Source, and Row Source Type. For some reason, the invoice number will just not allow the form to write the record.
Here are the combo box information sets:
Model: Control Source = Model
Row Source = tblModelC
Row Source Type = Table/Query
Status: Control Source = Status
Row Source = tblStatusC
Row Source Type = Table/Query
etc, etc.
For the Invoice combo box I have:
Inbound Invoice: Control Source = Inbound Invoice
Row Source = tblIncInvoicesC
Row Source Type = Table/Query
I understand the error says that it is trying to write something to a field that does not exist... but why? Just like the Category, Model, Manufacturer, I am simply selecting the Invoice Number so that it can write it to tblClientInventory with all of the other information too.
Now, here are the tables:
tblCategoryC
tblModelC
tblIncInvoicesC
tblClientInventory
I am assuming the error is telling me that the record in tblIncInvoicesC does not exist, yet that is impossible because I can select it from the combo box. Perhaps it is trying to write a different value where the field names do not match?
Any help would be greatly appreciated.
Thanks.