Have a database for which Im trying to create a form to input the same data for multiple instruments at the same time, with no luck. For now just trying to get GC 2 and GC 5 on the same form to input the data - I have started the form (Fm_GC) and would like for it to be workable, and for data to go to their respective GC_ Perf tables. Is there any way to do this?
Please see attached file.© BrainMass Inc. brainmass.com March 22, 2019, 2:15 am ad1c9bdddf
I have gone through your project. It is not possible to do it exactly the way you have started your form. If the data resides in different tables you need to use sub-forms. A form can be bound to just one table. However, I have taken another approach. I have created a query "MyUnion" that joins all of ...
An MS Access Database contains several performance tables. They are joined by query and a entry form is created with search filter.