Full Version: New Record With Form Bound To Qry
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
wilw
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?
MadPiet
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.
wilw
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.
JonSmith
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
wilw
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.