Form based on a query

S

srpadams

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
 
D

Duane Hookom

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.
 
Top