Hi
created a form with a data sheet view and ran it all ok
then set up a button to call the form via a macro and viewed my datasheet in form view.
After an hour or so of head scratching and trawling google found the option in the macro to change the view to datasheet.
Ok job done but it does raise the question of hierachy
MAcros seem to take precedence over form properties?
Does VBA take precedence over macros?
Can't seem to find an answer on the web?
THanks
Ian