Form Reads from one table Writes to another table

[Bee]

Hi,

I wonder if anyone can help with this please. I don't know if it's possible in Access:

I want to create a form that Reads from one table, but Writes to a different table.

Any examples, suggestions will be very much appreciated.

Thanks,
B

 

[Rabbie]

Its possible but we would need more detail to advise you further

 

[Bee]

I need to save new record into the Write table and here is a quick further explanation:

I basically have a DAT table that I use to look up information for a combobox. When the user selects any item of the combobox, the rest of the fields of that record are defaulted into a form. However, sometime the user may need to change some of the default information and save it. When that happens, I don't want the user to change the original default info in the DAT table. That's why I thought Reading from one table and Writing into another one might be appropriate for this.

Any thoughts please?
B

 

[neileg]

You could include all the fields from the Read table you want in the query that populates your combo box. Set the column widths to zero so the user doesn't see them. In the After Update event of the combo, use some code to set the values of your other controls that are bound to the Write table to those in the hidden combo columns. The user will still be able to alter these values if they wish.

 

[Bee]

I don't quite understand how the users will be able to alter the values! Do you mean the values will be altered after they are transefered into the Write table?

 

[neileg]

The controls on the form will be populated with the values. If these controls are bound to the Write table, a Save operation will put them to the underlying table. However until and unless the user updates the combo box entry, the values in thes controls can be altered at will. It's not a question of how, it's simply that there's nothing to stop the user changing these values. Only the combo box is bound to the Read table so there's no changing the data there.

See the attached example.

 

[Bee]

The controls on the form will be populated with the values. If these controls are bound to the Write table, a Save operation will put them to the underlying table. However until and unless the user updates the combo box entry, the values in thes controls can be altered at will. It's not a question of how, it's simply that there's nothing to stop the user changing these values. Only the combo box is bound to the Read table so there's no changing the data there.

See the attached example.

I could not receive the zip file. I wonder if you can remove its extension and resend it please. (Blocked by firewall)

 

[neileg]

Try this one.

 

[Bee]

That's a clever way of doing it - thanks for the example.