Search results
-
V
Navigation Forms - acBrowseToForm v SetFocus
would "MyTabControlName be the name of the button, Cost Details? I tried doing that and it didn't work -
V
Navigation Forms - acBrowseToForm v SetFocus
I've been searching all over because I know you all hate navigation forms but I have to bite! I have a form that's already been built and looks like this: Main Navigation Form includes the Edit Details button (among others). While I'm on the Project Details, I want to set focus to the Cost... -
V
Solved Pass value from subform to mainform
I didn't get anything for my Me.txtNotes = sRejectNotes -
V
Solved Pass value from subform to mainform
Yes, I believe you helped me with it...[Forms]![NavigationForm].[NavigationSubForm].[Form]![txtRequestTitle] -
V
Solved Pass value from subform to mainform
I looked at the link you shared and wrote this but nothing came out... In the Module: Public Function getValueFromPopUp(formName As String, PopUpControlNae As String, Optional MyOpenArgs As String = "None") As Variant 'FormName: Name of the popup form 'PopupControlName: Name of the control on... -
V
Solved Pass value from subform to mainform
Hi All, I've searched and only found ways to pass values from main form to sub form but not the other way around. Example: I have a form that when a button is clicked, another form opens to write a reason for the decision. This text will be used in an outgoing email. So Form 1: Form 1 is in a... -
V
Solved If ComboBox is Yes, TextBox must Not be blank
Yes, I moved all the datachecks to the BeforeUpdate event and the AppendQueries etc to the AfterUpdate event and the Submit button will only save and requery the form. Thanks for the advice! -
V
Print report from Form
Hi, I have a Navigation Form and I've added a report so that it's linked to the form by a field - Link Master Fields and Link Child Field so that the report displays the selected record. How can I get it to print? When the Print window pops up, the whole report is displayed rather than just... -
V
Solved If ComboBox is Yes, TextBox must Not be blank
bFinancial is a Yes/No combo box and is a required field that is defaulted to No, but if Yes is selected then txtFinancial needs something -
V
Solved If ComboBox is Yes, TextBox must Not be blank
Hi All! I want to add as part of a datacheck when the user clicks on Submit and Close. I have coding already there for other things, but how do I code for this? i.e. If Me.bFinancial = -1 then Me.txtFinancial not null I know that's not right, but I'm having trouble writing in the Not Null... -
V
Solved Display Yes/No dropdown instead of a checkbox in a form
What is the best way to accomplish this? In my table the field is set to Data Type:Format = Yes/No (Default Value is No) Under Lookup I changed it to Text Box so that it displays Yes/No instead of a checkbox on the table. When I add the field to my form I'd like it to display as a dropdown to... -
V
Solved Navigation SubForm opens another Form
You are fantastic!!! Thank you so much for helping me with this! -
V
Solved Navigation SubForm opens another Form
That worked to get rid of the error! -
V
Solved Navigation SubForm opens another Form
Thank you, I'll give it a try in the morning and let you know how it goes. -
V
Solved Navigation SubForm opens another Form
Yes, if exists, further down on the form the project deliverables location will be displayed -
V
Solved Navigation SubForm opens another Form
Sorry about that, let me clarify NavigationForm - Create New tab - frmRequests.txtProjectNumber = frmMultipleRequests.txtProjectNumber (and txtProjectDeliverables) This part is what you sent me earlier and works well as long as I have numbers as values, but if I enter an alphanumeric value it...