How do I move input data from one place in a form to a specified field in a table.

[rbowman40]

I am trying to design a form in which a category (field in a table) is selected from a combo box, then a value for that category is entered in a form field. I want that value to be placed in the field selected from the drop down list in the combo box. It would be like what happens when a bookkeeper selects an account field from a list and then enters a value for it. The value is then appended to the specified account field. I think this should be something easy, but I can't figure it out. I have made forms where an input field matches a table column, but I can't figure out how to specify the column (field) and then have the value go there. I would like a user to have just a couple of places to deal with in data entry instead of a massive form. I am pretty inexperienced with Access. Maybe I know only enough to be dangerous. :-/ Thanks.

I have Access 2003 running on XP Pro

[MMcCarthy]

OK.... the code now looks like this:

Private Sub Go_OnClick()
DoCmd.RunSQL "UPDATE Transdistribution SET [" & Me.Account_Name & "]= & Me.Amount"
End Sub

This says make account_Name field in Transdistributi on = Amount

Because you haven't specified which record you want to do it in with a where statement it will change every record to that amount.

[rbowman40]

Hmmmm . . . I better go back to the first code. Can't do it this afternoon though. Thanks for all you help to this point. Sorry I'm sort of thick about this.

[MMcCarthy]

Hmmmm . . . I better go back to the first code. Can't do it this afternoon though. Thanks for all you help to this point. Sorry I'm sort of thick about this.

Another possibility to try is something like

 
Private Sub Account_Name_AfterUpdate()
 
   Me.Amount.ControlSource = Me.Account_Name
 
End Sub
 
 

This will only work if the form is bound to table Transdistributi on and the current record being viewed is the one you want to update.

[NeoPa]

OK.... the code now looks like this:

Code:
Private Sub Go_OnClick()
DoCmd.RunSQL "UPDATE Transdistributi on SET [" & Me.Account_Name & "]= & Me.Amount"
End Sub


Did I do that right?

I know this is going a way back in the 'conversation' but this looks like you're trying to set the name of the account to an ammount or numeric value.
Is this really what you want?
If you specify your table layouts (list relevant fields) and form to be used (list relevant controls) then we can put something together for you. It's much easier to work with named specifics.

[MMcCarthy]

I know this is going a way back in the 'conversation' but this looks like you're trying to set the name of the account to an ammount or numeric value.
Is this really what you want?
If you specify your table layouts (list relevant fields) and form to be used (list relevant controls) then we can put something together for you. It's much easier to work with named specifics.

Hi Adrian

I understood that the combo box had a list of field names relating to certain type of accounts and the figure could be assigned to different fields depending on requirements. Therefore, the combo box has a list of the relevant fields.

I may be wrong??

Mary