Apr 23 2012, 03:44 PM
A form is bound to a qry based upon a tbl. Appending a new record from the frm needs to go to the tbl not the qry. Is a subform needed for the new record?
Apr 23 2012, 03:46 PM
a query does not contain data. it's a view of a table. If the query is based on a single table, you can base a form on it, and then write records to the table the query is based on.
Apr 23 2012, 04:18 PM
No, the qry is based upon several tables that have relationships created. So a new frm is required to add new records to the main table.
Apr 23 2012, 04:22 PM
It sounds like you either don't understand how queries work or are not explaining what you are trying to achieve very well (I always find its better to state that rather than how you are trying to achieve something).
Can you give some more info please
Apr 23 2012, 06:48 PM
There is an input/edit/display form bound to a query that takes data from a main table linked to a few other tables. If the frm is bound to just the table how do the other fields not in the tbl get displayed? I tried dlookup to the query for the other fields but it didn't work.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here