Sprinks,
Thanks, I see what you're saying. What I did though was pull the value from
a previous form. The previous form is a form where the user chooses a
vendor, then clicks a command button to open a seperate form to fill out
purchase order information for that vendor. On the second form, I just
pulled over the vendor name so my control source for the text box is:
=[Forms]![frmVendor]!VendorName
I need to take this value somehow and save it in the PurchaseOrder table.
The PurchaseOrder table is linked to the Vendor table in the relationships.
Does this make sense? Can I fix this?
Thanks
Sprinks said:
Hi, jped.
The textbox is most likely not bound to your field. Change the Control
Source property of the textbox to the name of the field in the underlying
table. If the field is not in the drop-down list, your form is likely based
on a query that doesn't include this field, rather than the actual table.
Check the form's RecordSource property for the name if it. Add the field to
the query first, and then you can bind the textbox to it.
Hope that helps.
Sprinks
:
I have a form where users input data. I have one field that is not adding
the information to the table behind it for some reason. Is there a way to
manually add the data to the table, say when the user clicks the command
button to view the report? Is there a line of code that can manually add the
data to the table? Please Help!
Thanks