Forms with dual Functions

[Guest]

I am a new user and is trying to create a Form that should do 2 basic
functions

1. Provide users with periodic infomation from another Data base which I
have done using Query?
1. Users to data enter updates based on the infomation provided in 1. above


I need help in creting this dual function Form. The environment is
Engineering Project based and the infomation in 1 above includes Project #'s
and Cost Budgets. The infomation to be entered by the external user includes
Project status, Comments etc.

DB

 

[Wolfgang Kais]

Hello Dawn.

I am a new user and is trying to create a Form that should do 2
basic functions

1. Provide users with periodic infomation from another Data base
which I have done using Query?
1. Users to data enter updates based on the infomation provided
in 1. above


I need help in creting this dual function Form. The environment
is Engineering Project based and the infomation in 1 above includes
Project #'s and Cost Budgets. The infomation to be entered by the
external user includes Project status, Comments etc.

The first "1." is possible by choosing your query as the recordsource
of your form. After setting the recordsource property, the fields of
the query are displayed in the field list that you can open in design
view of the form. Simply drag a field from the list onto the form.
The second "1." should be possible if the query is updatable and the
fields that have to be edited are also contained in the query. Add
these fields to the form as described in "the first 1." above.
If the users have to add multible records related to a project record
to another table, you can use a subform that is linked to the main
form. The easiest way to do this is by using the wizard that is
launched when adding a subform control to the main form by using the
toolbox (be sure that the wizards button in the toolbox is "on").
If the problem was that the records reside in another database:
You can link tables of external databases your database by ckicking
data, get external data, link... in the menu bar.