Pushing an update for list items

[googalabosh]

I need to push an update to the users to update the drop-down list items in one of the forms. When I test the update it doesn't seem to be updating the list items. Is there anything I should check or something special I need to do?

TIA

My setup (I know this will sound crazy but it's just how I have to have it)
1) The database is split into two parts: Front End and Back End)
2) The front end holds all the forms and queries. The back end holds the tables.


3) I've completed a minor update to one of the tables in the back end. I added a couple new columns and renamed another.
4) I have 5 drop down lists in a single form that need to be updated as easily as possible for the user. Some of the lists allow multiple selections.

[June7]

The setup sounds perfectly normal.

You did design changes to table. Now need to do design changes to UI to accommodate.

How does adding and renaming columns impact the 5 comboboxes?

[moke123]

Re-distribute the front end with all the changes.

[June7]

You say lists allow multiple selections. Are you using multi-value fields?

[beilstwh]

You have altered the tables in the backend. How is the front end database supposed to know about then. You will need to relink the tables in the front end so it knows about the new columns in the background database. If you want to use the new columns/tables you have to alter the forms and the query behind them to use the new information

[June7]

No, do not have to relink tables for new fields to be available in frontend.

[googalabosh]

Sorry for the late reply. Wasn't able to work on it again till today.

Redistributing the front end isn't working. As beilstwh stated, when I made the changes to the front end the back end doesn't know anything.

I'm thinking there must be a way to update the back end easily. If not, I'm guessing this is just going to be a mess of an update and lots of tech support hours from yours truly.

Any ideas?

June7: I'm using combo boxes with value lists and allowing multiple values.

[June7]

I am confused.

You edited backend to add fields and/or table?

You edited frontend to accommodate these backend design changes?

You provided users with new frontend?

What in the backend needs to be 'updated'?

If you are allowing multiple values selected by combobox then you must be using multi-value fields. I NEVER use multi-value field.

[googalabosh]

These are the days I wish I could just share it. LOL. No problem. Let me see if I can explain it better.

The front end contains a form with a sub form. The form is connected to Table A (located in the back end) and the sub form is connected to Table B (located in the back end).

I have added a couple of columns and renamed one column in Table B. After doing this I needed to add those columns in the sub form (located in the front end).

Hopefully that all makes sense.