I added something in the Form footer but it does not appear on the "Bottom" of the form. It is below the detail section but above the Datasheet. Is there any way to get the footer on the "Bottom"?
I added something in the Form footer but it does not appear on the "Bottom" of the form. It is below the detail section but above the Datasheet. Is there any way to get the footer on the "Bottom"?
if you are using the split form, don't think so. Options for the datasheet part are top, bottom, left right. Your form footer is part of the single form part of the split form, so appears at the bottom of that instead.
Don't think it will work, but you could try using the page footer instead.
It is very easy to design your own 'split form' with a lot more control of what appears where
1. Create a datasheet of the data you want to appear. Or simply create a copy of your main form and in the design view of the copy, in the form properties, format tab change default view to datasheet
2. in this datasheet form put the following code into the current event
on error resume next 'in case parent not available
me.parent.filter="ID=" & me.ID 'where ID is the primary key to your table, change as required
me.parent.filteron=true
save and close the form
3. in your main form, drag the copy into the footer section, size and locate as required.
4. in the subform properties, remove any values in the linkchild/master properties
Job done
Will do! Thanks