Need my form to retain records selected in Combo boxes

[J-LL]

I have a table of resin railcars, that have been shipped to our plant. I have
created a form that allows the user to select anyone of these railcars using
a combo box bound to a query (of said table). The user selects the railcar
that will be assigned for each of the 10 silos (that's 10 different railcars
assigned to 10 different silos).
The problem is: The form works great for making selections, but doesn't
retain them once I close the form. I would like the form to remember previous
selections until they are updated with a new railcar. Hope this is clear
enough...

Thanks,
J-LL

 

[KARL DEWEY]

Forms do not store data. Data is stored in tables. Use an event or macro
triggered by command button on the form to run an append query or an update
query.

 

[J-LL]

Thanks Karl.
Can you give me a short example of the steps needed to make an append query.
I can do the "Use an event or macro triggered by command button on the form"
part; I'm just not sure how to send the combo box values to an append query.
J-LL

 

[KARL DEWEY]

Create an append query by adding any table, select 1 in the icon window that
defaults to all (you do not want 500 records of the same thing), and for
design view field use --
My_Form_Field_1: [Forms]![YourFormName]![CboFirst]

For a date field use --
Date_Append_Field: #8/12/2008#

And select the appropriate Append To field.

 

[J-LL]

Thanks again Karl. I think I can do that.
Now, the question is: Is it possible to have the form open up to the same
set of values that were selected when the form was closed?

Create an append query by adding any table, select 1 in the icon window that
defaults to all (you do not want 500 records of the same thing), and for
design view field use --
My_Form_Field_1: [Forms]![YourFormName]![CboFirst]

For a date field use --
Date_Append_Field: #8/12/2008#

And select the appropriate Append To field.

--
KARL DEWEY
Build a little - Test a little

Thanks Karl.
Can you give me a short example of the steps needed to make an append query.
I can do the "Use an event or macro triggered by command button on the form"
part; I'm just not sure how to send the combo box values to an append query.
J-LL

 

[KARL DEWEY]

The easiest way to do that is NOT to do the append query but have the form
fields bound to the table by way of a select query.
Add to the open form method to go to the last record/max date/ or such.
--
KARL DEWEY
Build a little - Test a little

Thanks again Karl. I think I can do that.
Now, the question is: Is it possible to have the form open up to the same
set of values that were selected when the form was closed?

Create an append query by adding any table, select 1 in the icon window that
defaults to all (you do not want 500 records of the same thing), and for
design view field use --
My_Form_Field_1: [Forms]![YourFormName]![CboFirst]

For a date field use --
Date_Append_Field: #8/12/2008#

And select the appropriate Append To field.

--
KARL DEWEY
Build a little - Test a little

Thanks Karl.
Can you give me a short example of the steps needed to make an append query.
I can do the "Use an event or macro triggered by command button on the form"
part; I'm just not sure how to send the combo box values to an append query.
J-LL

:

Forms do not store data. Data is stored in tables. Use an event or macro
triggered by command button on the form to run an append query or an update
query.
--
KARL DEWEY
Build a little - Test a little


:

I have a table of resin railcars, that have been shipped to our plant. I have
created a form that allows the user to select anyone of these railcars using
a combo box bound to a query (of said table). The user selects the railcar
that will be assigned for each of the 10 silos (that's 10 different railcars
assigned to 10 different silos).
The problem is: The form works great for making selections, but doesn't
retain them once I close the form. I would like the form to remember previous
selections until they are updated with a new railcar. Hope this is clear
enough...

Thanks,
J-LL