TextBoxes update table whose record determined by Combo Box 1

[tomhughes]

I need to update 2 fields in a Table ("TableName") using two textboxes (txtBox1, txtBox2) whose unique record is determined by ComboBox2.

ComboBox1 selects a query which populates ComboBox2.

Can anyone help me with this ???

 

[lespaul]

You'll need to run an UPDATE query when the user presses a button after updating the information in txtBox2 that runs a query like:

UPDATE TableName SET field1 = Me.txtBox1, field2 = txtBox2 WHERE RecordID = me.ComboBox2



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[tomhughes]

Thanks lespaul - I appreciate your help. Do you know where I can find some VBA Access code ???

 

[lespaul]

You can browse Forum705 Access Modules (VBA Coding), I'm more of a query person not Access specific. I don't do any work in Access so I don't know where else to refer you for resources.

Leslie

 

[PHV]

One VBA way:

DoCmd.RunSQL "UPDATE TableName SET field1='" & Me!txtBox1 & "',field2='" & Me!txtBox2 & "' WHERE RecordID='" & Me!ComboBox2 & "'"

for each field defined as numeric, get rid of the corresponding single quotes.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886