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 |
#9
|
|||
|
|||
Data entry into table field.
You are of course absolutrly correct, but I did so because the down arrow to
which you refer simply shows an empty box and so there is nothing from which to choose. (I am reading the form and report design right now, interestings tips there, but the TRIM (command?) didn't work. I am trying to show a concatenated field of 2 numbers but there is always a space, even after I left justified the right hand (or second) number. I am very grateful for all your help, please don't give up on me. Thanks very much. -F "strive4peace" wrote: that means you used an equation as the Controlsource -- not the name of a field. In the controlsource property, make a choice from the list (note the arrow on the right when you click in that property) Warm Regards, Crystal remote programming and training Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day * FBrnstrmr wrote: after adding the controlsource I cannot choose antry from the combobox it says "can't be edited it is bound to the expression ....etc." "strive4peace" wrote: the ControlSource is the field name (from the form RecordSource) that the combo is bound to "How do I link the form data to the table once it is made" put the table name in the form RecordSource to create a new record, click the [*] button in the lower left corner of the screen where the navigation buttons are Warm Regards, Crystal remote programming and training Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day * FBrnstrmr wrote: How does the data chosen from a drop-down list or combo box get entered into the table field? How is it linked to the record as opposed to (or in addition to) the combo-box? I appear to have worked in reverse in that I created a Form to enter data from a combo-box, but don't yet have the place to store the chosen data. How do I link the form data to the table once it is made, please? Since the data will be new how does it create a new record for that data? Thanks in advance for any help you may provide. -F |
Thread Tools | |
Display Modes | |
|
|