One Form for many Tables

[leelu1317]

I did not go to school for programming but I do have some knowledge. What I'm trying to do is create one form for my end users to use to update information in several tables.



Here is my scenario I have three tables. Each table is for a specific reagent and has all the same column headings (received date, expiration date, etc.). I want my form to use a combo box to select the table for whatever reagent I'm entering data for and filter or send the data to that table. Not sure if I can do this.

I would love to not have to make a form for every reagent that I have to enter into this database.


Leelu1317

[ItsMe]

You can use code to assign a value to the Form's Recordsource property.
Me.recordsource = me.comboName.Value

[June7]

Instead of 3 reagent tables, should be 1 with another field for reagent type. Select reagent from combobox to save value to that field. Apply filter to select the desired set of records.

[Missinglinq]

As June7 has indicated, three identical Tables, one for each reagent, violates normalization rules, and in the end will cause you to have to duplicate more than just Forms!

And what happens if a 4th reagent is added? And a 5th? You'd have to add another Table!

Follow June7's suggestion and add a Field for the reagent name.

Linq ;0)>