I have a subform in a main form that has an additional subform within it. The subsubform has a combo box for choosing invetory we have already moved once to move a second time, but I need the combobox to accept new info for inventory that did not come back to base first and is going to a 2nd destination. The problem is that I have enabled edits and not confined the combobox to the list but when you type in the stock number it disappears. If I go into the table and enter the info it will stick but not from the subsubform.
Tabs(mainform)
stock(subform)
-stockdriver(subsubform)
-stocksubhauler(subsubform)
BOL(subform)
-BOLdetails(subsubform)
-BOLdriver(subsubform)
-paymentdetails(subsubform)
-bolsubhauler(subsubform)
customers(subform)
Reports(subform)
Check register(subform)
Drivers(subform)
The one that I am having problems with is the BOLdetails subsubform that has a lngstock combobox that pulls stock numbers but should alos allows additions for stuff that is not in stock. I really dont know what is going on I have tried changing it from datasheet to continous removing the relationship between the stock and boldetails tables and I am at a loss anyone with any ideas would be appreicated.
I tried changing the combo box to a text box and that works, but when you go back to review the info it doesn't show the stocks in the subform its just blank.
Ok I just fixed it a different way had to have allow edits set to no. So thanks for looking everyone but Its fixed, I guess.
Tabs(mainform)
stock(subform)
-stockdriver(subsubform)
-stocksubhauler(subsubform)
BOL(subform)
-BOLdetails(subsubform)
-BOLdriver(subsubform)
-paymentdetails(subsubform)
-bolsubhauler(subsubform)
customers(subform)
Reports(subform)
Check register(subform)
Drivers(subform)
The one that I am having problems with is the BOLdetails subsubform that has a lngstock combobox that pulls stock numbers but should alos allows additions for stuff that is not in stock. I really dont know what is going on I have tried changing it from datasheet to continous removing the relationship between the stock and boldetails tables and I am at a loss anyone with any ideas would be appreicated.
I tried changing the combo box to a text box and that works, but when you go back to review the info it doesn't show the stocks in the subform its just blank.
Ok I just fixed it a different way had to have allow edits set to no. So thanks for looking everyone but Its fixed, I guess.
Last edited: