Form based on a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have multiple tables that I needed to use on a form that is updatable. I
can update existing records and they are visible on the form, but any new
records I create are not on the form, but they are in the tables. I have
requeried on the event tab in properties OnClose and OnOpen but still I can't
see the new records.
I have even manual requeried. I don't have any criteria in my query. Is
there a better way to add multiple tables to a form for the purpose of
updating the info?
Thanks
Stephanie
 
I rarely use more than one or two tables as the record source for a report.
If I need to include other tables, they are usually "child" records that can
be displayed, added, and edited in a subform.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

set value of txtbox in form = select query 2
Append Query Issue 0
Brain Freeze help with combobox and query 7
Instant Totals on Continuous Forms 1
Deleting & Re-querying From A Union Query 11
Query to Form View 1
Access Dcount (multiple criteria) 3
Why it deletes my query? 2

Back
Top