Ashu
Reputation: 31
How to fill value of on textbox based on value of other in ms-access in continuous forms for each record
I have a continuous form which is filled by a table. Now when a user wants to edit a textbox on the form I want to populate another textbox on the same form. This would happen on the exit event of the firts text box.
Please suggest options, can I use dlookup or use vba to iterate through recordset and then fill corresponding record textbox. Share a code snippet can I use to find which record textbox is edited an fill corresponding one.
Upvotes: 0
Views: 1360
Answers (1)
uttam patel
Reputation: 43
You can do like this, first textbox 1 and take one command button write one macro which contian logic of fill textbox on click command button and Fill value of corresponding textboxs value base on textbox1 value
Upvotes: 0
Related Questions
- Customizing MS Access Form field Look-up based on results from another field value on form
- How to loop through the rows of a continuous form in microsoft access and insert value into unbound textbox using vba?
- Loop through textboxes on access form and change the data
- Assigning a textbox value to a multiple table/query field values
- Passing the value on a textbox control to a new record using the same form
- How to auto lookup & fill record if checkbox is checked in MS Access
- Access 2016 Form auto-populate based on another field
- Populate Text box on report based on value on another form
- Assign value to a text box on form based on multiple text boxex value with if condition - MS ACCESS
- Autopopulate Text based on control value