ccoldfire
Last Activity: Jul 10 '16, 04:31 PM
Joined: Feb 23 '16
Location:
-
That exactly what i did,thank you -
changing control formating if it's value changed in form
hi to you all
am trying make the control formatting changes when changing it's value to keep track of what controls i've changed in the form,wither it was a combobox or textbox .
i had this idea of making the control checks the value in the table's field which is bounded to,so if they are not equal,so i tried Conditional Formatting using the "not equal to" and point it to the field in the table which is the control is bounded... -
dlookup in form that returns the closest value
hi to yo all
lets say we have this table
tbl_city
ID ------- city
10 ------- london
20 ------- barcelona
30 ------- paris
and a form that consist of two text box(txt1,txt2), in the first one i enter a number and the other one contains a dlookup function that will run that number against tbl_city and will return the city name which its ID is the closest to the one i entered....
No activity results to display
Leave a comment: