Swtiching views

[Guest]

Hi there,

I have a data entry form in Single form view. I want to be able to click a
button and have the form view switch to Continuous such that i can see a
history events against a specific record. Can this be done?

 

[Brett Collings [429338]]

Hi there,

I have a data entry form in Single form view. I want to be able to click a
button and have the form view switch to Continuous such that i can see a
history events against a specific record. Can this be done?

Carlee, I would put your history events in a datasheet subform. That
way, you can select the main record on your single form and the
history for that record is automatically displayed. Both forms will
be visible as one, no switching required.

This supposes that you have two tables, one with the main information
and the other with the history items. That would be the normal
structure for a Relational Database which is what Access plays with so
well.


Cheers,
Brett