Search results

Many, many, many thanks again, @arnelgp. This is really a very simple and smart solution! I had not thought of such a decision - first to change the focus to the Tab and then to open Pop up form! Аbsolutely smart decision! Sometimes really have to think "out of the box". To look for the right...

He Here is my database and what I need is: On my main form "frmInspection" on subform "frmPSD" I have cboAscertainment and cboNumberOfProducts. The cboAscertainment has 2 оptions - "no violations" and "violations". When I number in cboNumberOfProducts it automaticly open popup form...

No, I need depending on what choice is made on combobox "cboType" on subfrmPSD, when I presse the Exit button On my unbounded pop up form "frmProducts" to open different tab pages. Something like that, but this is for subform2 to subform1 If Me.[Parent]![cboType] = "somename" Then...

Hi everyone, On my unbounded pop up form "frmProducts" I need to write code that when I press Exit button onClick evetn to refer that: If combobox (cboType) on my subform "subfrmPSD" is = "somename" then DoCmd.GoToControl "InspectionTab" ElseIf my subform "subfrmPSD" is = "somename" then...

Thanks for the advice and help, arnelgp!

Thank you, Mr arnelgp for your help. Тhe code works perfectly, but in my case the combobox, that I want to after update is located on the form Which is into Page1 Oh, I just added: Me.Parent.Page2.Visible = .Combo5.ListIndex > -1, and now the code works perfectly for me! Thanks again, Mr arnelgp...

I sent you a PM

I made 2 of 3 tab pages (with TabCtl514) invisible when loading the main form (frmInspecion) with the code: Private Sub Form_Load() Me.Prescriptions .Visible = False Me.Аcts.Visible = False End Sub The first tab page (with form frmPSD and Page Index 0) is always visible...

Тhanks for the advice!

Wow, thank you, sir Uncle Gizmo, for your time and the prepared visual material on YouTube. For the detailed explanation you made for me. Thank you and for you, theDBguy! I appreciate your patience and the help you give me. Тhe question I was trying to ask and explain is: Is it possible to...

Uncle Gizmo, I'am trying but I don't see any change. When I make a new entry in "subfrmInspections" and I choose "PSD" form cboTypeOfInspecion, it is open form "frmInspection" goes to page"psdTab" on form "frmPSD", BUT psdID is stays on "(New)". So I want to be created automatically next new...

I redesigned my database in english to explain clearly what I need. As well as where the data comes from. As I said when I choose cboTypeOfInspecion = "PSD" (on form "subfrmInspections") and it is open form "frmInspection" and page tab "psdTab" (form "PSD"). I need when the form "frmInspection"...

Yes, I want the subform to open and add new data automatically

I apologize for the explanation. Here's what I want - that new record to be next new record created (new data) automatically,

I need when Main form and sub form are open, the sub form automatically create new record

Уou are right. Do you know how can I do that?

Need to open subform in acFormAdd

Hi, all, How to open in add mode (acFormAdd) subform "frmPSD" (on Tab control - page "psdTab") on Main form "frmInspection"? Main form and subform are linked with Fields. The Main form "frmInspection" is open by another form with the code: Private Sub cboType_AfterUpdate() If Me.cboType =...

Hi all, I have function name mdValidateData to validate data in my subform which is on Navigation Control - Page Index 0 On Main form I have the following codes: Private Sub Form_Load() 'Add controls in order ctls.Add Me![fm_PSD]![cboInspection] End Sub Private Sub Form_BeforeUpdate(Cancel...

Both options work properly. Thank you very much for your help and advice, MajP, arnelgp, Gasman. I appreciate it!