I am trying to write a short and simple macro that will bring up the data
form so that the user can search for records.

When I use:

ActiveSheet.ShowDataForm

The data form that comes up only has the title box.... not the fields for
the other 10 categories as well. But when I click on Data and Forms myself
the data form comes up with all the fields.

Why doesn't the macro bring up the full data form?