Jumat, 30 Desember 2016

[MS_AccessPros] Generic Form/Subform and Control Guidance

 

I should have asked this question many, many hours ago and saved myself a lot of time.  Now that I have a learned a little more via the school of hard knocks, I see that I need a "standard process" to replace my hit and miss practice of Requery form, Requery combo, set to nothing, etc.  I have just been guessing at what to do based on the Monkey see, Monkey do practice.

I am not asking for the code at this time.  Focusing on the code has added to my confusion to this point.  I think I can find that later (but I may have to come back and ask some specific question).  For now I am looking for general practice guidelines in plain English so that I can understand what the purpose of the code is.

Here is the general situation I am hoping to establish a standard practice for.  I have the following:

Mainform = MF
unbound combo box controls in the MF header, ubc1, ubc2 and ubc3
     ubc2 is filtered on the value of ubc1, and ubc3 is filtered on the value in ubc2

Mainform details section contains a bound combo (bcb1) which is filtered on the value in ubc2

Subform = SF with control name the same as the subform name, which is linked to the main form via Link fields, so the SF is requeried each time the main form record pointer is changed.  However, the subform contains bound combo boxes sfbcb1 and sfbcb2, which need to be refreshed based on changing values in main form detail fields.  sfbcb1 is filtered based on the value in MF bcb1 and sfbcb2 is filtered based on the value of MF txt1.  

In this scenario, to improve user experience, when and where should I set the various cbo's to "nothing"?

Which events do I use, and which controls do I use to Requery the forms and combo boxes?

Do I ever need to force a Requery of the subform, or just leave that process to Access and the link fields?

To make take this less time for someone to answer, see the following format (If I could insert a table in this message this would be easier)

Main Form
     Event = (OnCurrent, etc)
     Action = (set record pointer, Requery something, set cbo's in main form header to nothing, etc)
ubc1
     Event =
     Action =
ubc2
     Event =
     Action =
ubc3
     Event =
     Action =
MF bcb1
     Event =
     Action =
MF txt1
     Event =
     Action =

Or answer in any format you choose, I am just trying to make it easy for someone to help me.
Thank you.
David
      



__._,_.___

Posted by: david.pratt@outlook.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar