Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update field in table based on value in a different text box

Status
Not open for further replies.
dleewms

dleewms

Programmer
Aug 19, 2001
118
US
Hi,

I am using Access 2007. I have a text field on my form (txtPartNumber) that is correctly populated based on the choice in a combo box. The txtPartNumber field is locked so user can't change it. I need to update the part number field in another table which is also on the form [Part No] with the value from the txtPartNumber field. I created the following simple experssion, but it didn't work. Can anyone help?

Thanks!

Code: 
Private Sub txtPartNumber_AfterUpdate()
Me.[Part No] = Me.txtPartNumber

End Sub

 
Status
Not open for further replies.

Similar threads

PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
442
PrimoSteve
PrimoSteve
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
561
Kennelbloke
Kennelbloke
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
191
caykamanj1966
caykamanj1966
Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
2K
dhookom
dhookom
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
653
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top