[RESOLVED] Dynamic field order on subform datasheet view

[deedub84]

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

[sparbag]

Hello,
Do you want to have the subform as an actual form instaed of datasheet view? If so set the subform to either a single form or continuous form, depending on your design.
If not then I think I misunderstood the question.

Steve

[deedub84]

I decided that I needed to go a different route -- creating a form on the fly based on a template so that I can manipulate the fields during data input.

Thanks for your help!