Trouble linking a subform correctly.

[CraigWarmy]

I been having trouble linking my data together. For the main form and subform:
Master Field:RoomID
Child Field:RoomID

Table Linkage:
TableNames:Accessories.AccessoriesID to AccessoriesLI.AccessoriesID
TableNames:AccessoriesLI.AccessoriesLineItemID to AccessoryPricing.AccessoriesPricingLineItemID
TableNames:AccessoriesCategories.AccessoriesCategories to AccessoryPricing.CategoryID

The tab order in the sub-form is: Category,PartName,Cost, CostType and Price. Each time that I try to change the category combobox, I lose each line entry that I have just made, such as part name. Any help??

 

[Galaxiom]

I had a different problem once but it was where a table and its key field both had the same name. Unfortunately I can't remember the symptoms but I have always avoided it since.

Might be worth checking out in your situation.

 

[CraigWarmy]

I think I have found a solution to the problem. Add a text box that hold the text of the combobox. Column(0) has the linking ID while the Column(1) data has the text value and assigns it to the invisible textbox. After making using the cbobox, make it invisible and make the textbox visible.