Saving Records permanatly.

[Guest]

I create several records using my form [frm_NewQuote] and the records save in
my table [tbl_QuoteInfo]. Several of my options within my records are combo
boxes linked to other tables whichh hold current prices for options. What I
want is to be able to create a record using my form which is linked to all of
the tables, but when when I save it, I want the information to just not be
linked anymore. this way if I change prices for an option, I don't have to
worry about a past quote being corrupted with new prices.

If this is clear or understandable then let me know and try to clarify a
little more.
Thanks in Advance.
Travis

 

[Guest]

Travis the simplest way I can think of is to not have the fields as links IN
your Table just set the properties correctly. Then on your form use an
unbound combobox to link to your lists (which get updated) when they select
the price or the data use the OnChange command to have the values copied to
the actual record's field (which I normally place on the form but not have it
visable.

This way the data is set in the record and is not updated as the list data
changes. Just remember if the rocrd is open and the price/data is changed it
will be changed in your record as well.

-David

 

[Guest]

I think this will work. But what would my Code be for the OnChange?

Travis the simplest way I can think of is to not have the fields as links IN
your Table just set the properties correctly. Then on your form use an
unbound combobox to link to your lists (which get updated) when they select
the price or the data use the OnChange command to have the values copied to
the actual record's field (which I normally place on the form but not have it
visable.

This way the data is set in the record and is not updated as the list data
changes. Just remember if the rocrd is open and the price/data is changed it
will be changed in your record as well.

-David
--
David O'Malley

I create several records using my form [frm_NewQuote] and the records save in
my table [tbl_QuoteInfo]. Several of my options within my records are combo
boxes linked to other tables whichh hold current prices for options. What I
want is to be able to create a record using my form which is linked to all of
the tables, but when when I save it, I want the information to just not be
linked anymore. this way if I change prices for an option, I don't have to
worry about a past quote being corrupted with new prices.

If this is clear or understandable then let me know and try to clarify a
little more.
Thanks in Advance.
Travis

 

[Guest]

What I want to do is make a selection based on a table or Query, I want the
ID to go into one textbox and the price to go into another. For Example:
I have Combo Box [ModelID] which is based off a table. [ModelID] has the
ModelID hidden but shows me [Model Name] and [Cost]. When I select my Model I
want Text100 to show the ModelID and Text101 to show the Price.

Hope you can help.
Thanks in Advance.
Travis

I think this will work. But what would my Code be for the OnChange?

Travis the simplest way I can think of is to not have the fields as links IN
your Table just set the properties correctly. Then on your form use an
unbound combobox to link to your lists (which get updated) when they select
the price or the data use the OnChange command to have the values copied to
the actual record's field (which I normally place on the form but not have it
visable.

This way the data is set in the record and is not updated as the list data
changes. Just remember if the rocrd is open and the price/data is changed it
will be changed in your record as well.

-David
--
David O'Malley

I create several records using my form [frm_NewQuote] and the records save in
my table [tbl_QuoteInfo]. Several of my options within my records are combo
boxes linked to other tables whichh hold current prices for options. What I
want is to be able to create a record using my form which is linked to all of
the tables, but when when I save it, I want the information to just not be
linked anymore. this way if I change prices for an option, I don't have to
worry about a past quote being corrupted with new prices.

If this is clear or understandable then let me know and try to clarify a
little more.
Thanks in Advance.
Travis

 

[Guest]

Travis,

You will use the OnChange for [ModelID] thru the CodeBuilder and use:

[Text100].Value = [ModelID].Value
[Text101].Value = [Cost].Value

--
David O''''Malley

What I want to do is make a selection based on a table or Query, I want the
ID to go into one textbox and the price to go into another. For Example:
I have Combo Box [ModelID] which is based off a table. [ModelID] has the
ModelID hidden but shows me [Model Name] and [Cost]. When I select my Model I
want Text100 to show the ModelID and Text101 to show the Price.

Hope you can help.
Thanks in Advance.
Travis

I think this will work. But what would my Code be for the OnChange?

Travis the simplest way I can think of is to not have the fields as links IN
your Table just set the properties correctly. Then on your form use an
unbound combobox to link to your lists (which get updated) when they select
the price or the data use the OnChange command to have the values copied to
the actual record's field (which I normally place on the form but not have it
visable.

This way the data is set in the record and is not updated as the list data
changes. Just remember if the rocrd is open and the price/data is changed it
will be changed in your record as well.

-David
--
David O'Malley


:

I create several records using my form [frm_NewQuote] and the records save in
my table [tbl_QuoteInfo]. Several of my options within my records are combo
boxes linked to other tables whichh hold current prices for options. What I
want is to be able to create a record using my form which is linked to all of
the tables, but when when I save it, I want the information to just not be
linked anymore. this way if I change prices for an option, I don't have to
worry about a past quote being corrupted with new prices.

If this is clear or understandable then let me know and try to clarify a
little more.
Thanks in Advance.
Travis

 

[Guest]

What does "Value" represent?

Travis,

You will use the OnChange for [ModelID] thru the CodeBuilder and use:

[Text100].Value = [ModelID].Value
[Text101].Value = [Cost].Value

--
David O''''Malley

What I want to do is make a selection based on a table or Query, I want the
ID to go into one textbox and the price to go into another. For Example:
I have Combo Box [ModelID] which is based off a table. [ModelID] has the
ModelID hidden but shows me [Model Name] and [Cost]. When I select my Model I
want Text100 to show the ModelID and Text101 to show the Price.

Hope you can help.
Thanks in Advance.
Travis

I think this will work. But what would my Code be for the OnChange?

:

Travis the simplest way I can think of is to not have the fields as links IN
your Table just set the properties correctly. Then on your form use an
unbound combobox to link to your lists (which get updated) when they select
the price or the data use the OnChange command to have the values copied to
the actual record's field (which I normally place on the form but not have it
visable.

This way the data is set in the record and is not updated as the list data
changes. Just remember if the rocrd is open and the price/data is changed it
will be changed in your record as well.

-David
--
David O'Malley


:

I create several records using my form [frm_NewQuote] and the records save in
my table [tbl_QuoteInfo]. Several of my options within my records are combo
boxes linked to other tables whichh hold current prices for options. What I
want is to be able to create a record using my form which is linked to all of
the tables, but when when I save it, I want the information to just not be
linked anymore. this way if I change prices for an option, I don't have to
worry about a past quote being corrupted with new prices.

If this is clear or understandable then let me know and try to clarify a
little more.
Thanks in Advance.
Travis

 

[Guest]

NEVERMIND....Had a brain fart there. Sorry

What does "Value" represent?

Travis,

You will use the OnChange for [ModelID] thru the CodeBuilder and use:

[Text100].Value = [ModelID].Value
[Text101].Value = [Cost].Value

--
David O''''Malley

What I want to do is make a selection based on a table or Query, I want the
ID to go into one textbox and the price to go into another. For Example:
I have Combo Box [ModelID] which is based off a table. [ModelID] has the
ModelID hidden but shows me [Model Name] and [Cost]. When I select my Model I
want Text100 to show the ModelID and Text101 to show the Price.

Hope you can help.
Thanks in Advance.
Travis

:

I think this will work. But what would my Code be for the OnChange?

:

Travis the simplest way I can think of is to not have the fields as links IN
your Table just set the properties correctly. Then on your form use an
unbound combobox to link to your lists (which get updated) when they select
the price or the data use the OnChange command to have the values copied to
the actual record's field (which I normally place on the form but not have it
visable.

This way the data is set in the record and is not updated as the list data
changes. Just remember if the rocrd is open and the price/data is changed it
will be changed in your record as well.

-David
--
David O'Malley


:

I create several records using my form [frm_NewQuote] and the records save in
my table [tbl_QuoteInfo]. Several of my options within my records are combo
boxes linked to other tables whichh hold current prices for options. What I
want is to be able to create a record using my form which is linked to all of
the tables, but when when I save it, I want the information to just not be
linked anymore. this way if I change prices for an option, I don't have to
worry about a past quote being corrupted with new prices.

If this is clear or understandable then let me know and try to clarify a
little more.
Thanks in Advance.
Travis