help with creating a form

[Txlonghorn76]

I would like some suggestions on how I should best design a form. Our team
will be updating this project form on a weekly basis. Here are the things I
need help with:

1. There are some fields such as Project Name and Start Date that will not
change. Those fields I would like to find a way to automatically pull from
the datasheet. How do I do that?

2. The fields that are updated weekly need to be submitting to a
table/datasheet. How do I allow it to submit?

Do you think I should have 2 data sources: 1 to receive the data and one to
submit the data?

 

[Golfinray]

You need only one data source. A form with a recordsource of a table will
automatically update to that table unless you don't want it to. I usually put
a command button to save on the form just for the sake of the users, but it
saves by itself.

 

[Txlonghorn76]

I am still a little confused so I should clarify my form requirements.

1. The top half of the form that contain the fields that do not change: I
want to be able to enter the Project ID# and have the other fields
autopopulate

2. the bottom half that does change: I would like this part to be entered
manually and then added to the table.

How do I do this?

 

[Golfinray]

Use a search function to find the record you want to update. Add a combo box
to the form, allow the wizard to do this and set the recordsource of the
combo to your project ID#. Right click on the combo and go to properties.
Under properties, click on events and go to the afterupdate event. Click the
little button out to the right and start the code builder. Type:
Me.filter = "[project id#] = """ & Me.combo# & """"
Me.filteron = true
The combo# will be listed, like combo1 or combo22. This will get you the
search function. For the top half of the form the records will remain the
same if the they are the same in your table. The bottom half will allow
updates and save to the table.

 

[Txlonghorn76]

excuse me for asking too many questions but can you explain what you mean by
"use the search function"? Thanks!

Use a search function to find the record you want to update. Add a combo box
to the form, allow the wizard to do this and set the recordsource of the
combo to your project ID#. Right click on the combo and go to properties.
Under properties, click on events and go to the afterupdate event. Click the
little button out to the right and start the code builder. Type:
Me.filter = "[project id#] = """ & Me.combo# & """"
Me.filteron = true
The combo# will be listed, like combo1 or combo22. This will get you the
search function. For the top half of the form the records will remain the
same if the they are the same in your table. The bottom half will allow
updates and save to the table.

I am still a little confused so I should clarify my form requirements.

1. The top half of the form that contain the fields that do not change: I
want to be able to enter the Project ID# and have the other fields
autopopulate

2. the bottom half that does change: I would like this part to be entered
manually and then added to the table.

How do I do this?

 

[Golfinray]

The search function I described is used to autopopulate forms. In other
words, after you add the search function combo box, you will click on it,
scroll down to the project ID# you want to see, and it will populate your
form with the information about that ID# from your table or query.

excuse me for asking too many questions but can you explain what you mean by
"use the search function"? Thanks!

Use a search function to find the record you want to update. Add a combo box
to the form, allow the wizard to do this and set the recordsource of the
combo to your project ID#. Right click on the combo and go to properties.
Under properties, click on events and go to the afterupdate event. Click the
little button out to the right and start the code builder. Type:
Me.filter = "[project id#] = """ & Me.combo# & """"
Me.filteron = true
The combo# will be listed, like combo1 or combo22. This will get you the
search function. For the top half of the form the records will remain the
same if the they are the same in your table. The bottom half will allow
updates and save to the table.

I am still a little confused so I should clarify my form requirements.

1. The top half of the form that contain the fields that do not change: I
want to be able to enter the Project ID# and have the other fields
autopopulate

2. the bottom half that does change: I would like this part to be entered
manually and then added to the table.

How do I do this?

:

You need only one data source. A form with a recordsource of a table will
automatically update to that table unless you don't want it to. I usually put
a command button to save on the form just for the sake of the users, but it
saves by itself.

:

I would like some suggestions on how I should best design a form. Our team
will be updating this project form on a weekly basis. Here are the things I
need help with:

1. There are some fields such as Project Name and Start Date that will not
change. Those fields I would like to find a way to automatically pull from
the datasheet. How do I do that?

2. The fields that are updated weekly need to be submitting to a
table/datasheet. How do I allow it to submit?

Do you think I should have 2 data sources: 1 to receive the data and one to
submit the data?

 

[Txlonghorn76]

few things I would like your help with:

1. The combo box is not showing me a list of all Project IDs in the control
source table.

2. The remaining top half does not search even though I entered the code you
gave.

The search function I described is used to autopopulate forms. In other
words, after you add the search function combo box, you will click on it,
scroll down to the project ID# you want to see, and it will populate your
form with the information about that ID# from your table or query.

excuse me for asking too many questions but can you explain what you mean by
"use the search function"? Thanks!

Use a search function to find the record you want to update. Add a combo box
to the form, allow the wizard to do this and set the recordsource of the
combo to your project ID#. Right click on the combo and go to properties.
Under properties, click on events and go to the afterupdate event. Click the
little button out to the right and start the code builder. Type:
Me.filter = "[project id#] = """ & Me.combo# & """"
Me.filteron = true
The combo# will be listed, like combo1 or combo22. This will get you the
search function. For the top half of the form the records will remain the
same if the they are the same in your table. The bottom half will allow
updates and save to the table.

:

I am still a little confused so I should clarify my form requirements.

1. The top half of the form that contain the fields that do not change: I
want to be able to enter the Project ID# and have the other fields
autopopulate

2. the bottom half that does change: I would like this part to be entered
manually and then added to the table.

How do I do this?

:

You need only one data source. A form with a recordsource of a table will
automatically update to that table unless you don't want it to. I usually put
a command button to save on the form just for the sake of the users, but it
saves by itself.

:

I would like some suggestions on how I should best design a form. Our team
will be updating this project form on a weekly basis. Here are the things I
need help with:

1. There are some fields such as Project Name and Start Date that will not
change. Those fields I would like to find a way to automatically pull from
the datasheet. How do I do that?

2. The fields that are updated weekly need to be submitting to a
table/datasheet. How do I allow it to submit?

Do you think I should have 2 data sources: 1 to receive the data and one to
submit the data?