Generalized Form to update tables not in Form

[cmmrfrds]

I have a Form based on a query to several tables, which tables I do not want to update. The Form is to provide a variable template to update other tables in the database. The tables in the underlying query are actually metadata that is used to determine how many rows and columns need to appear on the Form. The User then enters data in the rows and columns which are parsed to built inserts to other tables. The problem is that I can't enter data in the Form unless the underlying tables are updateable, which I don't want to happen. ANY IDEAS ????<br>
<br>
Is there a simpler way to solve this problem?<br>
<br>
The design is to allow Users to enter Measurement/Test data on many different types without needing a separate form for each Type.

 

[DougP]

If you have your forms recordsource connected to just one table, say the main table and create subforms for the other tables then you should be able to add data to each.<br>
So each table is connected to just it's recordsource and NO query.<br>
You can with a little finesse make it look like one trasparent form.<br>
OK <br>
Try making a new form and leave your exixsting form alone in case you need to refer to it.<br>
I do this when I run into your situation.<br>
<br>
<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[cmmrfrds]

Thank you for your suggestions Doug. I will try your suggestions. I have a work around for now, but will need to change it. My work around is not a long term solution but I need to deliver the software ( as a prototype) tomorrw and it will satisfy the functionality of the application. I will include the redesign in the next release and may be coming back with more questions then.