Linking an existing unbound textbox to a new field?

On my Orders form, I had a text box called "Tip" for a dollar amount. It
seems I need to have that information recorded in a field now, when it was
just a textbox entry in the past. I added the field (i.e. Tip) to the Orders
table, but I'm not sure how to link it. Is that possible?

Thanks

EZ KEY wrote:
On my Orders form, I had a text box called "Tip" for a dollar amount.
It seems I need to have that information recorded in a field now,
when it was just a textbox entry in the past. I added the field
(i.e. Tip) to the Orders table, but I'm not sure how to link it. Is
that possible?

Thanks

First make sure that your form can "see" the new field. In design view of the
form press the button in the toolbar to display the "Field List". Is the new
field listed? If so, then just enter that field name as the ControlSource
property of your TextBox control.

If it is NOT shown in the field list then your form is based on a query, not the
table directly and you will need to modify that query so it includes the new
field. Click the build [...] button to the right of the RecordSource property
of the form to modify the query. Then proceed as described above after adding
the field.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Rick:

Thanks for the quick response. Sorry I didn't respond sooner.

I have been creating this thing on 2002 version of Access. A week or so ago
I downloaded the trial version of 2007 and I love it. I was able to make the
fix with my 2007 trial because it also shows linked fields to the form
instead of just the main field forms. When I opened the field properties,
the field for Tip I needed was there. I dragged it in and "tah-dah", it
works. I think that and a few other perks has helped me decide on upgrading
to 2007.

Your notes helped. Thanks!

"Rick Brandt" wrote:

EZ KEY wrote:
On my Orders form, I had a text box called "Tip" for a dollar amount.
It seems I need to have that information recorded in a field now,
when it was just a textbox entry in the past. I added the field
(i.e. Tip) to the Orders table, but I'm not sure how to link it. Is
that possible?

Thanks

First make sure that your form can "see" the new field. In design view of the
form press the button in the toolbar to display the "Field List". Is the new
field listed? If so, then just enter that field name as the ControlSource
property of your TextBox control.

If it is NOT shown in the field list then your form is based on a query, not the
table directly and you will need to modify that query so it includes the new
field. Click the build [...] button to the right of the RecordSource property
of the form to modify the query. Then proceed as described above after adding
the field.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com