Help with query

[Guest]

I have a database that I track defective material. Within this database there
are several tables, quries and forms. I have one form I use to input
information on. I have another form that I use to track updates or commets on
a weekly basis. I would like to know if there is a way that when I enter
information onto the one form and some if this information is automatically
entered into another query. Example: I enter same a ID number, date, P/N,
description, qty. I would like to have the ID number, date, P/N and
description automatically entered into what I will call material updates
report and show up on the report as a NEW ITEM.

Right now when I enter information onto the form, I also have to enter
information on the material update form.

Can this be done?

 

[tina]

neither forms nor query store data. *tables* store data, that's essentially
all they do. queries retrieve data from one or more tables, for direct
manipulation and/or to make the data availabe to forms and reports. forms
present data from tables or queries, for display or data entry purposes.
reports present data from tables or queries, for display purposes only.

to display data from more than one table in a report, link the two tables in
a query and base the report on that query.

hth

 

[Guest]

You can build a query for your report and add a button on the form to run the
report.
The query for the report would use criteria like this --
[Forms]![YourForm]![YourIDField] for the ID number.
and
[Forms]![YourForm]![YourDateField] for the date.