Help!!!

[Guest]

I've set up a form in Access that pulls information from records in one table
to be used in another. It asks for a job number, then pulls up that record.
I need to be able to type in the empty fields located on this form. Does
anyone know how to do this?

 

[John Vinson]

I've set up a form in Access that pulls information from records in one table
to be used in another. It asks for a job number, then pulls up that record.
I need to be able to type in the empty fields located on this form. Does
anyone know how to do this?

How are the two tables related? You should almost certainly NOT be
copying fields from one table and storing the same data in another
table; the whole point of a relational database is that you enter and
store data ONCE, and then use queries to look it up.

Please explain what you mean by "to be used in another". I suspect
that a Subform will be appropriate, but don't know quite what your
structure is!

John W. Vinson[MVP]