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
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