Push Subform Info Into TextBox

[Maurita]

Hi, I am having trouble pushing info from a combobox in a subform to a
textbox in a subform. I know how to push information when choosing
data from a combobox to a textbox, but I am choosing info from a
form's combobox into a subform combobox. The subform combobox needs
to push data into a textbox which is in the subform.

Can this be done?

Thank you so very much.

Maurita Searcy

 

[John W. Vinson]

Hi, I am having trouble pushing info from a combobox in a subform to a
textbox in a subform. I know how to push information when choosing
data from a combobox to a textbox, but I am choosing info from a
form's combobox into a subform combobox. The subform combobox needs
to push data into a textbox which is in the subform.

Can this be done?

Thank you so very much.

Maurita Searcy

What have you tried? Just

Me!textbox = Me!combobox.Column(n)

in the combo's AfterUpdate [Event Procedure] should work. If the combo,
textbox, and code are all on the same form, it makes no difference that it's
being used as a subform.

 

[Maurita]

Hi, I am having trouble pushing info from a combobox in a subform to a
textbox in a subform. �I know how to push information when choosing
data from a combobox to a textbox, but I am choosing info from a
form's combobox into a subform combobox. �The subform combobox needs
to push data into a textbox which is in the subform.

Can this be done?

Thank you so very much.

Maurita Searcy

What have you tried? Just

Me!textbox = Me!combobox.Column(n)

in the combo's AfterUpdate [Event Procedure] �should work. If the combo,
textbox, and code are all on the same form, it makes no difference that it's
being used as a subform.

John,

Thank you for your response. I forgot to mention that the information
needs to be pushed in from a linked table which pulls in the Material
Number automatically, which is from table tblMaterial. The field in
tblMaterial that needs to be pulled in when the field MaterialNumber
is pulled from the combo box on my form is called Description. Since
my form automatically pulls in the Material Number when I click on the
combo box, I am unsure if the field MaterialNumber can pull the
Description from the same tblMaterial as well.

Thank you so very much.

Maurita

 

[John W. Vinson]

John,

Thank you for your response. I forgot to mention that the information
needs to be pushed in from a linked table which pulls in the Material
Number automatically, which is from table tblMaterial. The field in
tblMaterial that needs to be pulled in when the field MaterialNumber
is pulled from the combo box on my form is called Description. Since
my form automatically pulls in the Material Number when I click on the
combo box, I am unsure if the field MaterialNumber can pull the
Description from the same tblMaterial as well.

Thank you so very much.

Maurita

I can't see your database so I don't know what's where.

What's the RowSource for the combo box?
Does it contain the MaterialNumber?
What's Description? What table is it in, or what do you want to do with it?

Please explain what information you want to get, from where, and where you
want to put it.

 

[Maurita]

I can't see your database so I don't know what's where.

What's the RowSource for the combo box?
Does it contain the MaterialNumber?
What's Description? What table is it in, or what do you want to do with it?

Please explain what information you want to get, from where, and where you
want to put it.

John,

Thank you so very much for your help. This problem deals with two
tables, tblMain and tblAppend. My form is based on a query, and I use
a combo box to choose a customer service rep. When the customer
service rep is chosen, information is pulled in and of the fields, the
key field named Part Number is pulled in from tblAppend. I need
another field from tblAppend to be pulled into my form when Part
Number is chosen, the field called Part Name. Since this field is not
a key field, I am unsure how to pull it into the form since it is
automatically filled into my form.

I hope I have provided enough description of the fields and tables.
If not, please let me know.

Again, thank you so very much.

Maurita

 

[John W. Vinson]

Thank you so very much for your help. This problem deals with two
tables, tblMain and tblAppend. My form is based on a query, and I use
a combo box to choose a customer service rep. When the customer
service rep is chosen, information is pulled in and of the fields, the
key field named Part Number is pulled in from tblAppend. I need
another field from tblAppend to be pulled into my form when Part
Number is chosen, the field called Part Name. Since this field is not
a key field, I am unsure how to pull it into the form since it is
automatically filled into my form.

I hope I have provided enough description of the fields and tables.
If not, please let me know.

No, you have not.

You have told me what you are trying to accomplish and (sort of) how.

You have not - as requested - posted the structure of the tables or the SQL of
the query.

It sounds like you're trying to use a Form to move data from tblAppend to
tblMain. Why? Why not just run an append query? The data dosen't get stored in
the form after all!

 

[Maurita]

No, you have not.

You have told me what you are trying to accomplish and (sort of) how.

You have not - as requested - posted the structure of the tables or the SQL of
the query.

It sounds like you're trying to use a Form to move data from tblAppend to
tblMain. Why? Why not just run an append query? The data dosen't get stored in
the form after all!

John,

I am just referencing the Part Name in the form in an unbound textbox
for the user to see, it will not be resaved in the database. I can
not run an append query because other information in the subform will
be changed and resaved in the database. When I earlier tried using
the append query in the subform, I wasn't able to change the subform's
information, which I must be able to do. So, when the Part Number is
automatically filled in in the subform, it would be a good reference
for the user if the Part Name could also be seen.

I hope this clears things up. This database is very complex and also
uses an Excel spreadsheet imported periodically for additional
database information.

Thank you.

Maurita

 

[Maurita]

John,

I am just referencing the Part Name in the form in an unbound textbox
for the user to see, it will not be resaved in the database.  I can
not run an append query because other information in the subform will
be changed and resaved in the database.  When I earlier tried using
the append query in the subform, I wasn't able to change the subform's
information, which I must be able to do.  So, when the Part Number is
automatically filled in in the subform, it would be a good reference
for the user if the Part Name could also be seen.

I hope this clears things up.  This database is very complex and also
uses an Excel spreadsheet imported periodically for additional
database information.

Thank you.

Maurita- Hide quoted text -

- Show quoted text -

John,

Please disregard as the problem has been solved. I had not pulled in
the Part Name field to the underlying query. After I did this, I
changed my unbound text box on the form to a bound field, and the
information is pulled in as it needs to be. Thank you so much for
your time and patience. I guess that working on a database for days
with very little sleep does take its toll after a while.

Maurita