I have created a field in a table and set the field's data type to ole object.
I then included this ole object on a form. Access created a bound object frame that's bound to the ole object field.
Now, the help files say I need to click on the ole object in form view or datasheet view then click on the insert menu, click object and from there choose the object I want to use (I want to use excel in all cases).
I don't want the user to go through this every time for this field. I always want it to be an excel object.
I thought I could automatically insert the excel object into my ole object field on my table using the on focus event.
Does anyone have a clue as to how I can do this?