Form Form View from Design View

[gsrajan]

I have a split database. It takes very long time to go from form design view to form view. I did compact the database also. File size is only 2 MB. Any help is appreciated.

Thank you.

 

[bob fitz]

Does it take long to open the form directly from the db window.

 

[gsrajan]

Yes, you are correct. Once I do the changes in design, click on form view, it takes long time.

Thank you,

 

[bob fitz]

Does the form have many sub form, list boxes and/or combo boxes.

 

[gsrajan]

No, two combo and one list box. No subform

 

[bob fitz]

I would suggest saving the form with no record source and without any row source setting for the list box and combo box. Put some code in the forms On Open event to set these properties.