Enter Parameter Value

[Brownie772000]

I can't post it here. Sorry. I really do appreciate your effort. I know it is something very simple. I'm just missing


that one piece of the puzzle. I will search the query's and see if I find anything.

[Brownie772000]

I am a novice so please please bear with me. I am feeling lost. I will start from scratch and try to explain my question better.
I have a split DB in Access2007. 2 accdb files. Data.accdb and Forms.accdb.

I am dealing with 3 objects.
1. A backend table with appx. 50 fields
2. An identical frontend table
3. A form with a control for every field in these tables
When entering data in the various controls (mostly textboxes) on the form, the front end table temporarily stores this data. The form has a save button. When the save button is clicked all the data now in the front end table is stored in the backend table permanently.

I am trying to add a textbox to the form with the proper fields in both tables so the entering and storing protocal will work according to the above process.
Step by step how should I do this?

[June7]

A link is a direct connection to a backend table. Bind form to the link and data entry/edit will pass directly to the backend.

What you describe is not a table link. There must be some code behind the button that transfers data from frontend table to backend table. This code will have to be modified for the new field. Find this code and post it.

As for the 'Specify Relationship' GUI when adding the new field/control to form - no idea what that is.