Solved Add values from textbox and combo box to sub form (1 Viewer)

Sarah.M

Member
Local time
Tomorrow, 01:24
Joined
Oct 28, 2021
Messages
300
Hi, Plz note, My VBA is disabled for security reason.
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
1. I have Min from has ComboBox [Approved] , txtbox [Approved Date] and txtbox [Reason]
2. Sub form has the same ComboBox [Approved] , txtbox [Approved Date] and txtbox [Reason]
if I click on button I want the button by macro to take the information from From 1 to sub from 2
I use SetValue, it works but always if I click it it will change only the first Record of the sub form, I want if I click it keep go to next record

plz help :( 🙏
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:24
Joined
May 7, 2009
Messages
16,393
can you use Update Query?
 

Users who are viewing this thread

Top Bottom