Continous Form or Subform on Form?

[calvinle]

Hi,

I am wondering between 2 way of calculating data, but I Wonder if there is any difference positive vs negative using either way.

1/ Set the Form to Continous Form, and use the "Detail" to load the record, and Footer to edit the record, etc. There will be also Filtering, etc on that same form set to Continous. The positive thing here is I am having only 1 form that can have records in it. However, sometimes, it prompts the "Add/Update cannot without Edit" error message. I Wonder if because this way can cause this problem.

2/ Set the Form to Single, and add a subform to load the record. The bad of this is I will end up having 2 objects, the main form, and the subform.

I think the best way of the 2nd one, but I want to know if the 1st way is also good? What are the problem that can associate to the 1st way?

Thanks

 

[Ranman256]

I use continuous for overview. then if user wants detail, they click a DTL btn on the continuous form that takes them to the detail w subform

docmd.openform "frmDetail",,,"[clientID]=" & txtClientID

 

[missinglinq]

You don't mention what version of Access you're using, but if you're running 2007 or later you could use the new (as of 2007) Form View called a Split View or Form.

Part of the Form is in Datasheet View, while the other is in Single View...as you move from Record to Record, in the Datasheet View part, the current Record is displayed in the Single View part, making it easy to edit the Record.

You can adjust where/how you want the Datasheet View part to display and how big you want it.

Linq ;0)>