Recent content by Briguy01
-
B
Semi Unique Combox Record Source on Continuous Form
The public function I adapted had references that were bit off. I was trying to resize the subform after entering new record. I fixed the references and seems better. Moving focus onto mainform after entering also helped reduce vanishng acts (specifically if mainform record changed... -
B
Semi Unique Combox Record Source on Continuous Form
I was researching dynamic subform sizing and adapted a solution. I ended up with this which I think is a great start. I think I will need code to resize the mainform for when it does not need to be so large. In the context I will be using my application the subform usually holds 3-4 records... -
B
Semi Unique Combox Record Source on Continuous Form
-I copied the FilterCombo private sub into a private sub on the main form and changed the references to the subform control for combo requery. -I added Filter combo False to Main form OnCurrent event and mainform subform control OnExit event. -I added a little piece I am using in my main... -
B
Semi Unique Combox Record Source on Continuous Form
I will try the extra events first. Btw The resizing parts of CJ-London's project are kind of cool too. -
B
Semi Unique Combox Record Source on Continuous Form
I was just reviewing CJ-London's demo project "ContinuousCascadingCombo" and it seems to have vanishing issues as well. Specifically when you click on the productFK control on multiple records on left side continuous form view and then click into a field on right side datasheet view. I will... -
B
Semi Unique Combox Record Source on Continuous Form
I actually am experiencing some issues with the combo boxes going blank. Trying to pinpoint what is causing. -
B
Semi Unique Combox Record Source on Continuous Form
This appears to work quite well. Thanks a lot. Quite interesting approach to the solution! -
B
Semi Unique Combox Record Source on Continuous Form
Copy that. Right after I logged in after registering I was directed to post an introduction post. After that I attempted to post my question and sample db. Then I noticed the 10 post minimum in order to attach files. The subsequent posts to the intro commenced. June7 has replied in the... -
B
Semi Unique Combox Record Source on Continuous Form
I have a main form which tracks Task Information based on tblTask. There is a subform based on junction table tblTaskDetail. sfrmTaskdetail is a continuous form with a comboBox that looks up AssetID/SerialNumber. I found another post from this forum which was close to my issue...