Hi,

I'm barely out of the stage, but learning...

I am creating a database which has an input form, that depending on the customer, will present different fields that will feed a single 'InputData' table.

Ideally I would like the subform be tied to a form (rather than just a query), to allow for event-driven features such as if the product code is the same as the one before, fill in all the fields and jump to the next line (I have coded this already on a single input subform).

I know that I can set a field to be zero width which will cause it not to display in datasheet view. Is there a way to set the actual presentation order through VBA (I know I can set the tab order), but I'd like the input screen to match as closely as possible the input document that will be used (which depends on the customer).

Thanks,

DW