Coverting Subform from Data Sheet view to Continuous Giving Errors.

[deepakg27]

Hi Guys,

I have a frmSale and frmSaleDetailSubform (Subform). By default the subform is set to open in Datasheet view. I just changed it to continuous view and have been receiving following errors:

1. As I converted the form from Datasheet to continuous, When ever main form is opened or shifted between form view and Design view, it keeps asking for Enter Parameter Value ? tblSale.Bill



Pressing Ok OR Cancel OR entering any value has no effect , form opens fine but why gives an error??? How to avoid it. In datasheet view no error was there.



2. Secondly, Like in subform with Datasheet view when we keep pressing TAB and the record is blank, cursor moves to main form marking an end to the subform, but in continuous form cursor just keeps going in loops to the empty new record. Don't know why this is happening.

Thanks for any help or guidance.
Thanks and Regards
Deepak Gupta

[CJ_London]

1. not really enough information - is your mainform or subform based on tblSale? does it have a field called Bill? Have you checked the form properties for a filter or sort on a field no longer used? does you continuous form have any unbound controls?
2. check the form cycle property - under the Other tab

[deepakg27]

Hi Ajax,

Thanks for replying.

As per your suggestion I tried and built a very basic new DB and 1 problem was not showing in that, now I need to figure out where the problem in my main DB is (how do I figure it out, PLease suggest I am not very well versed in this). And Yes main frmSale is based on tblSale AND sub form frmSaleDetailSubform is based on tblSaleDetail (which has SaleID_FK to link it in 1 to Many Relationship).

2. Checked the other tab for Cycle Properties - it is set to All Records. Further pressing Ctrl+Tab snaps me out of Subform as it should and everything works fine after that. I feel we would need a small code here, where it should detect if all the columns are blank or Null after focus is lost , it should snap out of the subform to the next tab ordering in Main form.

Thanks and Regards
Deepak Gupta

[orange]

Note:
This is a follow on to post https://www.accessforums.net/showthread.php?t=72593

[Missinglinq]

...I just changed it to continuous view and have been receiving following errors:

1. As I converted the form from Datasheet to continuous, When ever main form is opened or shifted between form view and Design view, it keeps asking for Enter Parameter Value ...

If everything worked, as designed...then you simply went to Properties - Format and changed the Default View Property of the Subform from Datasheet to Continuous...doing nothing else...and it broke, now demanding a Parameter Value...you almost have to believe that Corruption has reared its ugly head!

Is the scenario I've described above exactly how this happened?

Linq ;0)>

[deepakg27]

Dear Linq,

This s exactly how it happened.

Thanks and Regards
Deepak Gupta

[CJ_London]

agree it sounds like corruption. Is your maindb in production and being used by others? If so do they each have their own copy of the front end and share the back end?

[deepakg27]

Dear Ajax,

Nothing of that sorts. It is used only on my laptop and that too in access DB file format have not converted it to stand alone yet. Any Idea on second issue.

Regards
Deepak Gupta

[CJ_London]

Not sure what the issue is

[deepakg27]

Dear Ajax,

Thanks