Saved changed revert after closing table (Split Database)

[jjake]

I have a split database. 2 tables.

Table 1 (tblForklift)
ForkliftID
ForkliftOwnerShip

Table 2 (TblForkliftOwnerShip)
OwnershipID
ForkliftOwnerShip

Table 1 Forkliftownership is a combo box and displays the correct columns in the back end, but when i go to the front end it will revert back to showing the ID and the row source will not be there. when i re-add the row source to the fron end and save it, close it and reopen it the row source will be gone and the table goes back to showing the ID.

 

[Ranman256]

the front end controls everthing the user sees
check the combo box properties.
columns = 2
columnwidths ; 1;1

 

[jjake]

The column properties look good. They also save when I close the table. The problem is the column count and the row source will not save as the respective table/query.

 

[MarkK]

FWIW, I wouldn't define a combo box in a table. Do that in a query or on a form. And your queries and forms are in your FE.

 

[jjake]

FWIW, I wouldn't define a combo box in a table. Do that in a query or on a form. And your queries and forms are in your FE.

I don't usually do this but I chose to for this one instance. I had to mass input data with a sub table and found it easier to copy and paste a lot of information this way.

 

[gemma-the-husky]

if you have a linked table, then you can't generally save properties for the linked table in the front end. only in the back end.

on the other hand, setting combo box details in the back end will only affect NEW combo boxes. Not existing ones.