If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Linking an existing unbound textbox to a new field?
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 |
#3
|
|||
|
|||
Linking an existing unbound textbox to a new field?
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 |
Thread Tools | |
Display Modes | |
|
|