Auto fill form

[sara_in_ga]

Hi,

I have a table that contains the following information:

Project number; Vendor; Owner; Comments

I would like to have a form that when the project number is filled out the
Vendor and Owner also fills in automatically. That way the user only has to
input comments regarding the update of the project.

I have tried everything but I am missing some thing somewhere. I am very new
to access.

Any help would be greatly appreciated.

Thanks,
Sara

 

[Damon Heron]

I would suggest that you need another table. This is because you will have
more than one comment entered for each project.
So, if you create a table called "Comments" with the projectnumber as a
foreign key, like so:

ID data type Autonumber
Commentfield data type Memo
ProjectNumber data type numeric

Then delete the comment field from your existing table.

Finally, create a form, with a record source of your first table, and add a
subform with your comments table as its recordsource. The link master/child
is projectnumber.

Users can cycle thru the projects to the one they want to comment on, and
enter the comments in the subform.
Any reports could be set up in a similar fashion.

Damon

 

[Klatuu]

If you mean the project record already exists and you want to navigate to it,
you will want to use an unbound Combo Box to search with. The combo box
wizard should walk you through creating the control. If not, post back, and
I can provide an example.

 

[sara_in_ga]

Klatuu - Thanks for your help.

Thanks, Sara

If you mean the project record already exists and you want to navigate to it,
you will want to use an unbound Combo Box to search with. The combo box
wizard should walk you through creating the control. If not, post back, and
I can provide an example.

Hi,

[quoted text clipped - 13 lines]

Thanks,
Sara

 

[sara_in_ga]

Damon,

Thanks for your help.

Thanks,
Sara

I would suggest that you need another table. This is because you will have
more than one comment entered for each project.
So, if you create a table called "Comments" with the projectnumber as a
foreign key, like so:

ID data type Autonumber
Commentfield data type Memo
ProjectNumber data type numeric

Then delete the comment field from your existing table.

Finally, create a form, with a record source of your first table, and add a
subform with your comments table as its recordsource. The link master/child
is projectnumber.

Users can cycle thru the projects to the one they want to comment on, and
enter the comments in the subform.
Any reports could be set up in a similar fashion.

Damon

Hi,

[quoted text clipped - 15 lines]

Thanks,
Sara

 

[Andrew]

From what I understand this can't be done on a continuous form. Is that
right? Do you know of an alternative?