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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I change the value of a field in a table from an unbound form?

Status
Not open for further replies.
Inky2201

Inky2201

Technical User
Jan 15, 2005
26
GB
I have a form that has been populated with a list of 16 parts (in 16 text boxes) by VBA code and is not saved or based on a table. On this form I want to "pull through" the value of a field in a table and carry out a calculation on this field to change the value in the table underneath. In other words to deduct a number that is generated on the form and take this number away from the field in the table. What is the best way to acheive this?

Regards
I
 
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
348
Andrzejek
Andrzejek
M
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
424
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Vba code I can call from a query to reformat text
Replies
8
Views
226
Moss100
Moss100
OzFoxy
  • Locked
  • Question
How to get AttachmentCount from a field in a table
Replies
2
Views
134
OzFoxy
OzFoxy
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
273
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top