Search results

Yes it is.

awesome - thank you.... I requeried the sub-forms (only) on exit and it works great. Thank you!

requery the subforms or mainform or both. The queries are comming from a remote db so if I have to requery the mainform that could slow things down a lot!!!

I have several sub-forms on a main form. I can combine a few but there will still be at a minimum two. If I edit the records on any of the sub-forms no problem. When I navigate to another sub-form no problem. When I edit date on a different sub-form I get a message saying that someone else...

If I understand correctly when you tab to a subform it only tabs within that subform's controls. Is there any way to have the subform (controls) just like any control on a main form? Tab -> Control 1 Tab -> Control 2 Tab -> subForm Control 1 Tab -> subForm Control 2 Tab -> Control 4 etc...

Is there a way to set/change the POPUP property just prior to (as you) opening the form. I have a form I would like to use/reuse. Depending on where I use it, I would like to either have it as a popup or as a main form that filled the screen. Does anyone have any ideas on this. I tried...

This is good to know, as usual I am doing something a little different (opening the form with arguments) so I am not sure if this will work. But I will definetely keep this handy. Thanks

Is there a way to open the same form twice. via DoCmd.OpenForm? I appreciate any help, Thank you,

Sigh... Thanks, though using multiple subforms or simply laying my forms out better may be the solution anyway. I appreciate your help,

In any form you can create objects that over lap. Sometimes on purpose such as turning one visible and another visible = false. I would like to do the same thing with objects and a subform. But the subform is ALWAYS on top of any objects there by covering (hiding) them. Do you know of any...

This not the best image. The red is data that can change. The blue is data that can not. Depending on the screen the data intermingles. Sometimes in the same column. But even here you can see how the data of both the form and subform are right next to each other. I was hoping to cover the...

I think I have a solution. I can use multiple subforms. Not as efficent but it works.

Okay, I think I still need help, I can't place any object on top of the subform. I have tried pushing the subform to the back. Bringing the objects to the front. The subform seems to be in the highest foreground. Any ideas how I can place an object on top of a subform???

This sounds like a lot of (extra) work. But if it works it will save a lot of unnecessary updating of duplicate data. This I gotta try.

??? Then can I over lay text boxes or combo boxes from the main form?

Unfortunately, this is not always convenient for the user. This is a good idea sometimes it segregates that data such that is looks confusing or misplaced on the screen. I may not have any alternative. Any other ideas?

I have asked this question before (sorry) but this time I'm going to a different approach/solution. I have two tables, one is not-updatable the other you can update. In Access if you do a query joining these two tables then the entire query is not updatable. Even the data that should be...

On further research (I should have done this first) it seems as it was designed this way as you said. The mouse scroll works in datasheet view but not form view so... I found this on the internet. http://allenbrowne.com/ser-70.html I loaded this into a new module and used the forms event and...

Ouch! That will be inconvenient, at least for us. Thanks,

Now I am getting nervous, that will dramatically impact the usability of several (many) of our screens/forms. I'm surprised that most programers and users prefer to maually select the next record(s) rather that scroll through them. Do I understand you correctly?