Search results
-
E
Open Form - Curser in first Header field.
Maybe this is overkill, but you can use VBA to do it. In design mode go to the properties of the whole form. Go to the events tab, click the dots next to "on load". Select CODE. In that window, type the name of the field then . then setfocus. Like this: searchfield.setfocus Edit: I took way... -
E
Ordering a Combobox - standard solution not working
Nope, got exactly the same result, even after closing and opening the form. I did in the process of testing this find out that new comboboxes work fine (I knew I was doing something stupid). Thanks for the help anyway. Edit: Even stupider reason: The VBA code changed the rowsource :eek:. This... -
E
Ordering a Combobox - standard solution not working
I feel like I'm doing something very stupid. I'm using access 2007. I've got a combobox, and I want the newest items (sortable by ProjectID or R_number - it doesn't matter) at the top. The row source is SELECT DISTINCTROW Projects.ProjectID, Projects.R_number, Projects.recv_date...